Search found 24 matches

by ep_datastage
Tue Jan 24, 2017 9:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: trying to load POSTGRES table with data from C-ISAM table
Replies: 15
Views: 9114

yes NLS is enabled, set at ms1252-cs , additionally I have UTF-8 set on the C-ISAM and POSTGRES sides. The characters are C# characters added by C# programs that run against the data on C-ISAM.
by ep_datastage
Mon Jan 23, 2017 5:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: trying to load POSTGRES table with data from C-ISAM table
Replies: 15
Views: 9114

trying to load POSTGRES table with data from C-ISAM table

Hi, I am trying to load a POSTGRES table with data from a C-ISAM table that contains C# characters.

I am able to extract the data from the C-ISAM tables just fine, but the load to POSTGRES fails due to these characters.

Any ideas ?


Thanks
by ep_datastage
Mon Dec 14, 2015 11:52 am
Forum: General
Topic: trying to dynamically schedule SEQ jobs in Data Stage
Replies: 8
Views: 2870

Sorry, Yes the values will include the job name, as well as the time it should run. That should be all that is needed. Currently I have 3 SEQ jobs that need to run based upon the values on this control table. But the SEQ jobs should only run if the date/time values from the control table meet the ru...
by ep_datastage
Mon Dec 14, 2015 11:17 am
Forum: General
Topic: trying to dynamically schedule SEQ jobs in Data Stage
Replies: 8
Views: 2870

Re: trying to dynamically schedule SEQ jobs in Data Stage

The values will determine which SEQ job will be scheduled and run. So based upon the value I would like to have a particular DS SEQ job run.

Thanks again
by ep_datastage
Mon Dec 14, 2015 10:19 am
Forum: General
Topic: trying to dynamically schedule SEQ jobs in Data Stage
Replies: 8
Views: 2870

trying to dynamically schedule SEQ jobs in Data Stage

Hi, I am new to DS and trying to dynamically schedule SEQ jobs in DS based upon values on a DB2 table. Can I do that and how do I accomplish that?

Thanks again
by ep_datastage
Thu Dec 10, 2015 10:45 am
Forum: General
Topic: passing a value from a db2 table to a datastage parameter
Replies: 4
Views: 2225

Thanks. Got it working.


Thanks again
by ep_datastage
Thu Dec 10, 2015 10:44 am
Forum: General
Topic: getting execute command stage output
Replies: 13
Views: 22422

Re: getting execute command stage output

Thanks for your help. Figured it out and it works as I was hoping/expecting.

Thanks again
by ep_datastage
Wed Dec 09, 2015 6:02 pm
Forum: General
Topic: passing a value from a db2 table to a datastage parameter
Replies: 4
Views: 2225

I have a job set up to read the DB2 table and write the value to a file.

I have added that to the SEQ job as the first job, then added a Exec_Command stage to attempt to read the file. But not sure at this point how to get the value I had read into a DS parameter
by ep_datastage
Wed Dec 09, 2015 12:05 pm
Forum: General
Topic: passing a value from a db2 table to a datastage parameter
Replies: 4
Views: 2225

passing a value from a db2 table to a datastage parameter

I am new to DS and need to read a table and pass the retrieved value to a DS parameter value.

For example, I read the table and get the file path and file location, I need to be able to pass that value to the SEQ File at the end of the process. How can I accomplish that?


Thanks