DSXchange

Thanks a million, Rich!

I got it worked.
TPQ

I use DB2 API stage and when I clicked on the Review Data button, I got the result correctly from the SQL that I wrote. But when I ran the job, the DB2 stage didn't recognize the environment variable. I tried with ODBC but it didn't work with the environment variable. I worked with the Server Name t...

Thanks to all for your advice. I have tried to hard code the values and I got the DB2 connection works fine. I tried to use GetEnvironment variable and I did get it. But as soon as I want to apply to the DB2 stage and I got the problem. I have read so much on this forum about this problem. Someone s...

Hi all, I have read all I could about the evironment variables on this forum. I created a user-defined environment variable under administrator as $Server_NAME. In my Job Properties, I add environment variable $Server_NAME under Parameters. In the default value, I could see the value that I put in b...

I used DB2 UDB Load to insert records into DB2 mainframe table. I at last got the job compiled OK and ran it. The job compiled fine but the run hang. The message on the log says "DB2_UDB_API_0,0: Logging delayed metadata." When I had to cancel it, the messages are " DB2_UDB_API_0,0: R...

Thanks, Shamshad for the reply. I did try to create a file in this folder and I got the file. Somehow, the job still failed. I highlighted the row of these properties and clicked the Property Help but I received "There is no help text defined for the selected property". Do you know why? Th...

I am too having problem of trying to use this stage. I gave a valid path name for all of the 3 properties that Sshettar mentioned above. The compilation went OK but the job failed on the error: DB2_UDB_Load_3,0: Fatal Error: Fatal: Internal Error: Function 'get_stage_prop' failed DSTAGE-UDB-0042`:`E...

DSguru2B wrote:

ArndW wrote:But, if there are only 2 updates per 100 records then doing it via the reject method might be more efficient; it depends upon the ratios.

True.

Yes, the update chance is small. I should use ArndW's method. The problem is I can't read it all.
Thanks,
TPQ

Hi, I'm trying to insert the rows into a table but if the row already exists, I want to update it with the new total = the old total plus the total from the row that I want to insert. Is there any DS variable which would change its value when the insert fails so I could use it to trigger my updates ...

Hi all, I'm new to DS and doing a pilot on this product. I'm trying to create a key column for my rows created by many stages. This column should start by the value of number of rows count + 1 from the table that I want to insert my rows in. I have tried many stages but haven't got what would work f...