DSXchange

Thanks All for your reply. I have passed the execute command activity (Using the Field function). Now, the issue I am facing is in this particular Select statement. select * from schema.table where update_ts > to_date(substr('2010-07-21 10:45:33.257868',1,19),'YYYY-MM-DD HH24:MI:SS') This is a DB2 T...

I have a Scenario as follows, *) I need to take Max(TimeStamp) from DB2 table *) Based on this Max(TimeStamp) value, i need to extract (Select *) from a DB2 Mainframe table. I tried doing it thru 2 jobs & calling it through a sequencer.(One execute command activity also) My first job will take M...

Thanks for your reply Anbu.

Is there any way to accomplish this in a single job?

Pls let me know whether are any alternate ways of doing this as I do not want to create 2 jobs for this.

Thanks,
Freddie

Hi All, I have a scenario where I need to extract the data from a Mainframe DB2 table(Table A) based on the condition given below. I have another table from where I need to take max(date)----Select max(date) from table B. Now, i need to pull the data from Table A based on the condition A.(Date) > ma...

I have one requirement in my project where we need to extract the data from Db2 table & send it across to the downstream as a FIXED WIDTH file. Can you pls help me to create this DataStage job & the functions I need to use to create a FIXED width file? Any help would be appreciated. Thanks i...

The issue here is, as I have 10 parameters (5 Mandatory & 5 optional), when i run the same job multiple times for different Source to Target loading, for few table loading, the optional might/might not have some values. Here is an example of how the Perl Script & the parameters look like. ./...

The issue is "The values for the Mandatory as well as the Optional Parameters" is coming from the Master scheduler.

Hi All, Request your help in resolving an issue with executing a Perl Script through DataStage. I have a Perl Script that needs to be executed through DataStage. This Perl Script has 10 parameters. ( 6 Mandatory & 4 optional paramaters). What are the different ways of executing this Perl Script ...

Hi All, Request your help in resolving an issue with executing a Perl Script through DataStage. I have a Perl Script that needs to be executed through DataStage. This Perl Script has 10 parameters. ( 6 Mandatory & 4 optional paramaters). What are the different ways of executing this Perl Script ...

Hi All, I am trying to generate the report of the DataStage jobs through the " DSJOB -report " function through a UNIX Script. It works fine for all stages except the DataSets. Whenever I use Dataset stage in a job, it is not generating the report details of the Dataset Stage (Like Stage N...

Hi All, I am trying to generate the report of the DataStage jobs through the " DSJOB -report " function into XML file. It works fine for all stages except the DataSets. Whenever I use Dataset stage, it is not generating the details of the Dataset Stage (Like Stage Name etc). Any help/resol...

Hi Ray, Thanks for your reply. I am encountering an error message as shown below while using the Db2 Connector Stage. Pls help. DB2_Connector_11: [IIS-CONN-DB2-000369] Error in environment configuration: The target table has 8 partitions but the environment configuration has 3 node(s) available. Mak...

Hi,

I am planning to do a Bulk Load to DB2 Tables. Pls suggest me the best way of doing it.

Also, pls let me know whether there are any prerequisites in the DataStage/Table level as well as any other settings that needs to be done to do it.

This is a parallel job.

Thanks
Freddie.

Thanks Kim & Craig for your valuable suggestions. I am using an Execute command activity that will read the Parameter file ( The file is somethin like this, filename1=/home/abc/file1.txt filename2=/home/xyz/file2.txt) I can grep the file & get the 2 values. I am struggling to capture these 2...

Hi All,

My requirement is simple. I have a Parallel Job Sequence. I need to read a parameter file (residing in the UNIX box,, it is a text file)& pass the values in the parameter file to the subsequent job activities.

Pls let me know how I can do it.

Thanks in advance,
Freddie.