Search found 105 matches
- Fri Jan 25, 2013 6:27 am
- Forum: General
- Topic: Passing value of table to where clause
- Replies: 1
- Views: 1568
Passing value of table to where clause
Hi, I have similar requirement as explained in this link. I did the same procedure for passing one run time value as parameter for 'where' clause the job 2. Steps followed: a. Created a routine "GetDate" with Arg1 and with code "Ans = Arg1" b. Created Job-1 to fetch the Data valu...
- Thu Jan 24, 2013 12:22 am
- Forum: General
- Topic: Issue in using file path in Routine
- Replies: 3
- Views: 1749
ArndW , I am sorry for the confusion, this is a issue with IIS Datastage 8.5 and its installed in unix. Yes, I am able to view that path via Datastage. Ray, I am not able to view your entire reply as I am not a premium member :( Can you please send me again in a format such that non-premium members ...
- Tue Jan 22, 2013 5:07 am
- Forum: General
- Topic: Issue in using file path in Routine
- Replies: 3
- Views: 1749
Issue in using file path in Routine
Hi, I have a routine which opens a file if it exists else it creates one. Note: This is only a part of actual routine If NOT(Initialized) Then * Not initialized. Attempt to open the file. Initialized = 1 Open "EndDateFile" TO StopDateFile Else * Open failed. Create the sequence file. EXECU...
- Thu Jun 14, 2012 8:36 pm
- Forum: General
- Topic: Is Server Edition supported by Win 7 ?
- Replies: 5
- Views: 2685
- Thu Jun 14, 2012 8:25 pm
- Forum: General
- Topic: Is Server Edition supported by Win 7 ?
- Replies: 5
- Views: 2685
Is Server Edition supported by Win 7 ?
Hi,
Just wanted to know if Datastage 7.5.2 Server Edition is supported by Windows 7.
Few blogs say the client is supported & the others say it might cause some issue while the jobs are run.
Please let me know. Thanks.
Regards,
dxk9
Just wanted to know if Datastage 7.5.2 Server Edition is supported by Windows 7.
Few blogs say the client is supported & the others say it might cause some issue while the jobs are run.
Please let me know. Thanks.
Regards,
dxk9
- Mon Jun 11, 2012 2:25 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: String to Date conversion issue
- Replies: 9
- Views: 4309
- Mon Jun 11, 2012 1:01 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: String to Date conversion issue
- Replies: 9
- Views: 4309
String to Date conversion issue
Hi, I have a input sequential file with a field value '2010-05-16'. Need to convert this into Date & load it into a Teradata table. Based on Dsxchange suggestions, I tried different combinations of oconv & iconv. But it doesn't work. The error says: Value treated as NULL Attempt to convert S...
- Tue May 22, 2012 4:36 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Working of Link Ordering
- Replies: 16
- Views: 7493
- Mon May 21, 2012 3:18 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Working of Link Ordering
- Replies: 16
- Views: 7493
- Sun May 20, 2012 9:33 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Working of Link Ordering
- Replies: 16
- Views: 7493
- Sun May 20, 2012 8:58 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Working of Link Ordering
- Replies: 16
- Views: 7493
- Sun May 20, 2012 8:32 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Working of Link Ordering
- Replies: 16
- Views: 7493
- Sun May 20, 2012 8:31 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Working of Link Ordering
- Replies: 16
- Views: 7493
- Sun May 20, 2012 8:12 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Working of Link Ordering
- Replies: 16
- Views: 7493
Working of Link Ordering
Hi, I have a job which reads data from DB2.. Upserts them into DB2 (link 1) & update a flag in DB2(link 2). How this works ?? Will the 1st record sent to Link 1 gets processed before its being sent to link 2 ?? Or the transformer link ordering doesn't have any impact on this & the records fl...
- Thu May 17, 2012 2:14 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Issue with Transaction Commit
- Replies: 2
- Views: 1703
Hi, Thanks for your response. The issue here is, we fetch rows from X where flag = 'N', and when it loads into Y, we also update the flag = 'Y' in X. The update cannot be done in different job cause everytime we have to run the File to update X job as well. So if the actual job fails, then the updat...