Search found 24 matches
- Thu Sep 22, 2005 3:42 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Conversion of string to Date
- Replies: 10
- Views: 5593
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...
- Thu Sep 15, 2005 7:35 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Conversion of string to Date
- Replies: 10
- Views: 5593
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...
- Thu Sep 15, 2005 5:12 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Conversion of string to Date
- Replies: 10
- Views: 5593
- Thu Sep 15, 2005 3:31 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Conversion of string to Date
- Replies: 10
- Views: 5593
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...
- Thu Sep 15, 2005 3:18 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: KeyMgtGetNextValue - Surrogate Key Generation
- Replies: 9
- Views: 5219
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...
- Thu Sep 15, 2005 3:08 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Conversion of string to Date
- Replies: 10
- Views: 5593
Conversion of string to Date
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, ...
- Thu Jul 21, 2005 12:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Help needed for Join Stage
- Replies: 8
- Views: 4110
- Sun Nov 07, 2004 10:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dataset handling
- Replies: 4
- Views: 3229
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 ...
- Thu Oct 28, 2004 10:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dataset handling
- Replies: 4
- Views: 3229
- Thu Oct 28, 2004 10:14 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dataset handling
- Replies: 4
- Views: 3229
Dataset handling
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...
- Fri Oct 15, 2004 1:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Garbled data on sequential file output
- Replies: 5
- Views: 2851
- Wed Oct 13, 2004 4:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fatal Error in all the jobs
- Replies: 5
- Views: 2783
- Wed Oct 13, 2004 4:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Join / Lookup Stage Reject Link
- Replies: 7
- Views: 9097
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...
- Wed Oct 13, 2004 4:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fatal Error in all the jobs
- Replies: 5
- Views: 2783
- Wed Oct 13, 2004 4:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Join / Lookup Stage Reject Link
- Replies: 7
- Views: 9097