Search found 227 matches
- Thu May 21, 2009 4:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue with Oracle enterprise
- Replies: 2
- Views: 2095
Issue with Oracle enterprise
I have a table to popluate and key ID field is a oracle sequence . There is a trigger on the table to populate sequence ID. When i try to populate the tabe using Oracle Enterprise , it is looking for ID field in the table regardless of me not mentioning the field in the columns. It throws a error No...
- Tue Jun 10, 2008 11:44 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to call a stored proc from OCI stage
- Replies: 4
- Views: 2210
- Fri May 23, 2008 11:43 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Dynamically Naming Sequential File
- Replies: 7
- Views: 6189
1) Firstly define a variable in the job something like FileDate in job parameters tab and leave the default value blank. 2)In the job sequence , connect execute command stage and job activity stage (call the job which needs the value) Execute command stage: In command tab give CAT in the parameters ...
- Thu May 22, 2008 11:12 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Dynamically Naming Sequential File
- Replies: 7
- Views: 6189
if i did follow you correctly , here is what you can try , 1) create a job which pulls the date value select to_char( max(pay_end_dt), 'YYYYMMDD') || '.csv' from my_table; and save the result in a flat file say FileDate.txt 2) create a job sequence with execute command stage in it which reads the FI...
- Tue May 13, 2008 10:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Migration from Datastage 7.5.2 to Datastage 8.0
- Replies: 2
- Views: 2205
- Tue May 13, 2008 10:12 am
- Forum: General
- Topic: Update to SDKSequences hungs
- Replies: 7
- Views: 5803
- Mon May 12, 2008 3:24 pm
- Forum: General
- Topic: Update to SDKSequences hungs
- Replies: 7
- Views: 5803
- Mon May 12, 2008 2:35 pm
- Forum: General
- Topic: Update to SDKSequences hungs
- Replies: 7
- Views: 5803
Ray , Nothing . My main purpose was to start a sequence 'SEQ1' with value other than 1. Since SEQ1 never created or existed in QA project , i ran KeyMgtGetNextValue routine in QA project and gave test value as 'SEQ1' (for example ) and it returned 1. After this i see SEQ1 listed in SDKSequences. Bef...
- Mon May 12, 2008 12:01 pm
- Forum: General
- Topic: Update to SDKSequences hungs
- Replies: 7
- Views: 5803
Update to SDKSequences hungs
I am not sure why below command hungs in qa project executing through DSADMIN which was working absolutely fine in dev project . UPDATE SDKSequences USING DICT VOC SET F1 = 'New_Value' WHERE @ID = 'Sequence_Name'; I am not able to update the seqname with new value . I created the seqname using sdk/K...
- Fri Mar 28, 2008 10:55 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Migrating Jobs from 7.5.2 to 8.0.1
- Replies: 5
- Views: 2902
- Fri Feb 22, 2008 7:19 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Problem reading file name
- Replies: 3
- Views: 2470
- Fri Feb 22, 2008 6:56 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Problem reading file name
- Replies: 3
- Views: 2470
- Fri Feb 22, 2008 5:48 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Problem reading file name
- Replies: 3
- Views: 2470
Problem reading file name
Filename i need to access has varying timestamp. I am trying to get filename at run time using pattern matching through command prompt. My command in Execute command Stage is dir ETLserverpath\R_test_Product* /B Output from command ====> R_test_Product_200802141522.csv I am passing this value to job...
- Fri Feb 22, 2008 12:33 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error
- Replies: 5
- Views: 2658
- Fri Feb 22, 2008 12:29 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: date problem
- Replies: 7
- Views: 3412
Mohandl,
I had similar requirement and my issue was resolved .Please look at thsi
post .
viewtopic.php?t=107975&highlight=
Thanks
Paddu
I had similar requirement and my issue was resolved .Please look at thsi
post .
viewtopic.php?t=107975&highlight=
Thanks
Paddu