DSXchange

Hi Saravanan, Thanks for your help. The problem was with some other field of the DB table defined as not null. This field was not part of the job and hence a null was trying to get into this field. However, the date fields when defined as varchar(10) in DS, the job runs fine. Thanks a lot for your h...

Yes you are right Phil. Effective_Date is the job parameter. I did try as you suggested to write into a sequential file. This works fine. I guess the problem is when its being written into the DB2/UDB target table. Is there any option available with DS server jobs where we can specify to convert a s...

Saravanan, I tried ur suggestion. Did not work and am getting the same error as before.

Phil, the parameter value is 2005-03-31 and I want to map this job parameter in the START_DATE date column in the target DB2/UDB table.

Thanks Phil for that correction. I got rid of OConv in the derivation and ran the job again. This time I did not get the first warning in my previous post but still got the second and the third one. Also I noticed in the director log that the computed value for START_DATE was incorrect. The log disp...

The sequences start with 1 and go on incrementing for each sequence name argument specified to this routine. For Eg: KeyMgtGetNextValue('X') will start from 1 and so will KeyMgtGetNextValue('Y'). Then onwards each sequence shall go on incrementing by 1 for each call made to them. If you want to rese...

Hi All, I have a requirement where I need to set a date column(of datatype date) of a target table in DB2/UDB with the value of a job parameter (Start_date). When I use the following derivation for mapping the job parameter into the column I am facing errors and nothing got inserted into the table, ...

Sequential files can be used in parallel jobs having the join operation. Try partitioning both the inputs to the join stage from within the join stage properties. Partition the data based on the key columns of the inner join.

IHTH.

Hi Amitava, That was the obvious thing to do I guess :D . Did that, but it still does not work. Throws me the following message : exec(): 0509-036 Cannot load program orchadmin because of the following errors: 0509-150 Dependent module /home/db2inst1/sqllib/lib/librwtool.a(librwtool.o) could not be ...

Hi Ray,

PATH environment variable is set to /usr:/usr/bin:/usr/vacpp:/usr/vacpp/bin in my project directory and these directories do not have dsrecords as well as orchadmin utilities under them.

What do u suggest I do now?

Thanks for your quick reply.

Hi All, I am not able to use the dsrecords or orchadmin utility for handling datasets from the unix prompt. I get the following error : ksh: dsrecords: not found. and ksh: orchadmin: not found. Can somebody guide me giving a step by step procedure for any setup to be done prior to using these datase...

Can you please provide some more information?

Okay!!!!!Can you please throw some light as to what exactly you are trying to achieve in this job of yours? Also can you please explain how have you implemented what you are trying to achieve so that we may help you better.

Thanks

Well I think u got my question wrong nitin. What I wanted to ask was is NULL or blank a valid value in the file which u are using as a reference file for the lookup? If not, then you can easily differentiate in the output records the records for which the lookup was not successful, by looking at the...

Hi Suneeth,

As per you, if the same jobs had run fine yesterday, can you check the format of the field for which the fatal error is thrown (today) in yesterday's file and confirm it to be same in today's file?

Thanks

Hi Nitin,

Is NULL or blank a valid value in the lookup file columns which are being outputted?