tag:blogger.com,1999:blog-31879330616507947592024-03-08T01:39:24.094-08:00Programmers NotesThis is notes/problems/solutions on db2 problems I have experienced.Anonymoushttp://www.blogger.com/profile/04458152548997546353noreply@blogger.comBlogger12125tag:blogger.com,1999:blog-3187933061650794759.post-44861002847563341702014-05-16T05:10:00.001-07:002014-05-16T05:10:06.817-07:00Import and Export of Google SitesI found this cool site for exporting and importing a google site via a JAVA app. Helped me alot.<br />
<br />
<a href="https://code.google.com/p/google-sites-liberation/wiki/UsersGuide">https://code.google.com/p/google-sites-liberation/wiki/UsersGuide</a>Anonymoushttp://www.blogger.com/profile/04458152548997546353noreply@blogger.com0tag:blogger.com,1999:blog-3187933061650794759.post-10729796929152131802014-02-12T05:06:00.004-08:002014-02-12T05:06:25.467-08:00Intranet (Google sites RSS Feeds)<div>
<br /></div>
<div>
We are currently still in the progress of deciding on which intranet solution to use, the 2 current top sites in the running is:</div>
<div>
<ul>
<li><a href="http://sites.google.com/">Google Sites</a></li>
<li><a href="http://papyrs.com/">Papyrs</a></li>
</ul>
<div>
The reasoning behind our not creating ourself is more on time constraints and the multiple requirements we have and the complications of that requirements.</div>
</div>
<div>
<br /></div>
<div>
<ul>
<li>Must integrate with google applications</li>
<ul>
<li>Send Mail</li>
<li>Receive Mail</li>
<li>Check Calender</li>
<li>Check Google Docs</li>
</ul>
<li>Wiki Creation</li>
<li>Integrate with Asana</li>
<li>RSS Feeds</li>
</ul>
<div>
So in affect to integrate the RSS (push) feed into your site is pretty simple, all you need is the page that you want to be subscribed to and add <b>"/posts",</b> remember the "S", at the end of the link. </div>
</div>
<div>
<br /></div>
<div>
For a complete toturial go to: <a href="https://sites.google.com/site/amslerclassroom/rss-feeds-for-google-sites">https://sites.google.com/site/amslerclassroom/rss-feeds-for-google-sites</a></div>
Anonymoushttp://www.blogger.com/profile/04458152548997546353noreply@blogger.com0tag:blogger.com,1999:blog-3187933061650794759.post-10849933237418315522014-02-12T04:55:00.002-08:002014-02-12T04:55:58.608-08:00RSS Feeds and MVCI will be doing some RSS feeds, integrating it with our current site and trying to keep you updated on the technologies we are using .Anonymoushttp://www.blogger.com/profile/04458152548997546353noreply@blogger.com0tag:blogger.com,1999:blog-3187933061650794759.post-32692152334622083492014-02-12T03:07:00.003-08:002014-02-12T03:16:18.671-08:00<h2>
MVC Paypal Integration</h2>
<br />
I had to do some paypal integration with MVC, and found this site which gives a nice tutorial on how it is done.<br />
<br />
<a href="http://logcorner.wordpress.com/2013/09/05/asp-net-mvc-paypal-integration/">http://logcorner.wordpress.com/2013/09/05/asp-net-mvc-paypal-integration/</a>Anonymoushttp://www.blogger.com/profile/04458152548997546353noreply@blogger.com0tag:blogger.com,1999:blog-3187933061650794759.post-68176000456616775602013-04-28T02:59:00.000-07:002013-04-28T02:59:17.293-07:00C# Database handler ClassA class I have written to handle dabase processes of a datagrid.<br />
<br />
<br />
using System;<br />
using System.Collections.Generic;<br />
using System.Linq;<br />
using System.Text;<br />
using System.Threading.Tasks;<br />
using System.Configuration;<br />
using System.Data.SqlClient;<br />
using System.Data;<br />
using System.Windows.Forms;<br />
using System.Collections;<br />
using System.Drawing;<br />
<br />
namespace StockCommander<br />
{<br />
class databaseHandle<br />
{<br />
String connectionString = @"Data Source=(localdb)\Projects;Initial Catalog=test;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;";<br />
SqlDataAdapter dataAdapter;<br />
DataTable table = new DataTable();<br />
<br />
public void GetData(string selectCommand, ref DataGridView dataGrid)<br />
{<br />
try<br />
{<br />
dataAdapter = new SqlDataAdapter(selectCommand, connectionString);<br />
SqlCommandBuilder commandBuilder = new SqlCommandBuilder(dataAdapter);<br />
table = new DataTable();<br />
table.Locale = System.Globalization.CultureInfo.InvariantCulture;<br />
<br />
dataAdapter.Fill(table);<br />
dataGrid.DataSource = table;<br />
<br />
dataGrid.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);<br />
}<br />
catch (SqlException)<br />
{<br />
MessageBox.Show("SQL Exception occured...");<br />
}<br />
}<br />
public void GetData(string selectCommand, ref DataGridView dataGrid, int identityColumn)<br />
{<br />
try<br />
{<br />
dataAdapter = new SqlDataAdapter(selectCommand, connectionString);<br />
SqlCommandBuilder commandBuilder = new SqlCommandBuilder(dataAdapter);<br />
table = new DataTable();<br />
table.Locale = System.Globalization.CultureInfo.InvariantCulture;<br />
<br />
dataAdapter.Fill(table);<br />
dataGrid.DataSource = table;<br />
table.Columns[identityColumn].AutoIncrement = true;<br />
table.Columns[identityColumn].AutoIncrementSeed = returnLastId();<br />
<br />
dataGrid.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);<br />
}<br />
catch (SqlException)<br />
{<br />
MessageBox.Show("SQL Exception occured...");<br />
}<br />
}<br />
public void updateData()<br />
{<br />
dataAdapter.Update(table);<br />
}<br />
<br />
private int returnLastId()<br />
{<br />
return table.Rows.Count + 1;<br />
}<br />
<br />
public void deleteRows(IEnumerator rowColl, ref DataGridView dataGrid)<br />
{<br />
while (rowColl.MoveNext())<br />
{<br />
DataGridViewRow currRow = (DataGridViewRow)rowColl.Current;<br />
dataGrid.Rows.Remove(currRow);<br />
<br />
}<br />
}<br />
public void setRowReadOnlyRows(ref DataGridView dataGrid,int i)<br />
{<br />
<br />
dataGrid.Rows[i].ReadOnly = true;<br />
dataGrid.Rows[i].DefaultCellStyle.BackColor = Color.LightGray;<br />
}<br />
<br />
public void setRowReadOnlyRows(ref DataGridView dataGrid)<br />
{<br />
for (int i = 0; i <= dataGrid.RowCount - 2; i++)<br />
{<br />
setRowReadOnlyRows(ref dataGrid, i);<br />
}<br />
}<br />
<br />
}<br />
}<br />
<div>
<br /></div>
Anonymoushttp://www.blogger.com/profile/04458152548997546353noreply@blogger.com0tag:blogger.com,1999:blog-3187933061650794759.post-65608324325113226652013-03-08T05:03:00.000-08:002013-03-08T05:03:14.552-08:00Party ModelCurrently implementing a "Agreement" level party model and just a basic party model.<br />
Some of the implementation include a library of addresses/phone records.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-u-QbCtP6Wj4/UTnhI2bB_EI/AAAAAAAABXA/l76T16xwQz0/s1600/Capture.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="http://3.bp.blogspot.com/-u-QbCtP6Wj4/UTnhI2bB_EI/AAAAAAAABXA/l76T16xwQz0/s320/Capture.JPG" width="238" /></a></div>
<br />
Will add some Python code on how I handled the library concept. As there is some complications to ensure that addresses is not being duplicated and that multiple addresses is linked to a single party and if updated the link is changed.Anonymoushttp://www.blogger.com/profile/04458152548997546353noreply@blogger.com2tag:blogger.com,1999:blog-3187933061650794759.post-261236945968191832013-02-11T00:10:00.004-08:002013-02-11T00:10:59.374-08:00Errors :(I got a error: "SQL0668N Operation not allowed for reason code 5".<br />
<br />
The web and DB2 help gave me the description that a load was busy hapening which in this case was not True.<br />
In the end the real error was because I had was doing a load as below:<br />
<br />
DECLARE CURSOR1 CURSOR FOR<br />
SELECT column1,column2<br />
from table1 where ID not in (select ID from <span style="background-color: yellow;">TABLE2</span>);<br />
<br />
<br />
<br />
LOAD FROM CURSOR1OF CURSOR<br />
INSERT INTO <span style="background-color: yellow;">table2 </span>(col1,col2);<br />
<br />
Because the Cursor contains the table in which the load is being done it gives the reason code 5.<br />
Anonymoushttp://www.blogger.com/profile/04458152548997546353noreply@blogger.com0tag:blogger.com,1999:blog-3187933061650794759.post-57383303424607171642013-01-31T08:55:00.002-08:002013-01-31T08:55:28.142-08:00IBM Data studioA quick update on my experience. The selects is working great, the only thing I am missing currently from my winsql is that I can click on a foreign key and it retrieves the row for me.Anonymoushttp://www.blogger.com/profile/04458152548997546353noreply@blogger.com0tag:blogger.com,1999:blog-3187933061650794759.post-65498375123122439632013-01-31T08:53:00.000-08:002013-01-31T08:53:04.409-08:00OptimizationNext week I am planning a in-depth analysis on my experience in optimization a data take on script. The scripts writes 20 million to a staging file then do data manipulation and writes to several different tables.<br />
<br />
Then there is about 1 million records to be compared with the 20 million records and then written to a staging area and then manipulated before written to multiple tables.Anonymoushttp://www.blogger.com/profile/04458152548997546353noreply@blogger.com0tag:blogger.com,1999:blog-3187933061650794759.post-8884452440671798222013-01-14T04:33:00.000-08:002013-01-14T04:33:01.486-08:00IBM Data StudioBecause of the JAVA it takes a bit of resources and is a bit slow. Otherwise I have no complaints. All the database and sql management operations can be done on this tool.<br />
<br />
Some searching may be required to do some advanced operations.Anonymoushttp://www.blogger.com/profile/04458152548997546353noreply@blogger.com0tag:blogger.com,1999:blog-3187933061650794759.post-16833355993190350692013-01-09T22:42:00.001-08:002013-01-09T22:42:25.298-08:00IBM Data studio<b>Update:</b><div>
First impressions is not bad, the only current issue I have is the amount of data that has to be downloaded. The initial download is to installation package about 160mb then a further 800mb for the rest of the packages. </div>
<div>
<br /></div>
<div>
<br /></div>
Anonymoushttp://www.blogger.com/profile/04458152548997546353noreply@blogger.com0tag:blogger.com,1999:blog-3187933061650794759.post-36348416670966534532013-01-09T03:19:00.002-08:002013-01-09T03:19:49.578-08:00New Development ToolDownloading the IBM Data studio and will give feedback if it actually helps in a business environment. The reason for downloading is that I have a couple of functions and scripts that needs some debuging and statistical information. So hopes this helps.<br />
<br />
Current development software is WINSQL...<br />
<br />
<a href="http://www.ibm.com/developerworks/downloads/im/data/">http://www.ibm.com/developerworks/downloads/im/data/</a>Anonymoushttp://www.blogger.com/profile/04458152548997546353noreply@blogger.com0