Hi ,
Can any one tell me the difference bet ween Sequential file and Dataset?
Can we delete the Dataset?Can we copy the Dataset?
Search found 48 matches
- Fri Jan 25, 2008 5:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: What is the difference between sequential file and Dataset
- Replies: 3
- Views: 2782
- Fri Jan 18, 2008 5:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to handle this type of job where reference file has morc
- Replies: 1
- Views: 1077
How to handle this type of job where reference file has morc
Hi ,
My reference file has 15million rows of data ,source file has 500 rows due to lack of cache for reference file the jobs gets aborted (source and referencs files are sequential files)
How to handle this situation for better performance.
My reference file has 15million rows of data ,source file has 500 rows due to lack of cache for reference file the jobs gets aborted (source and referencs files are sequential files)
How to handle this situation for better performance.
- Fri Jan 18, 2008 5:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to call a environment variable in a job level
- Replies: 2
- Views: 2024
How to call a environment variable in a job level
Hi ,
can any one suggests how to call a environment variable in the job level that is already defined at the project level
can any one suggests how to call a environment variable in the job level that is already defined at the project level
- Tue Nov 20, 2007 10:44 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Templates
- Replies: 5
- Views: 2052
- Tue Nov 20, 2007 6:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Templates
- Replies: 5
- Views: 2052
Templates
Hi all, I created the a template from a existing job design and I got the message that the template was created successfully. But I was unable to view it from the repository of designer. can any one give some information on this ,like where these can stored ,from where we are able to access,what are...
- Mon Nov 19, 2007 6:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Using filter
- Replies: 9
- Views: 3596
- Mon Nov 19, 2007 5:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Using filter
- Replies: 9
- Views: 3596
Without a reject link (which is what you originally asked about) your final WHERE condition needs to contain the logical inverse of the combination of all your other WHERE conditions. For example col ... hi ray , My requirement is like this ,I has one source and using the filter I need to send the ...
- Mon Nov 19, 2007 1:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Using filter
- Replies: 9
- Views: 3596
The complete set, if you please. The message suggests that you have nominated link number 11 somewhere (numbering starts from 0). We need to determine whether that is the case. You can post the rel ... Hi ray , I changed the link names ,numbered from 0 ,it works fine. In this case I have given the ...
- Mon Nov 19, 2007 12:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Using filter
- Replies: 9
- Views: 3596
Please post your complete set of WHERE specifications from your Filter stage. Without them it is impossible to advise. ... Hi ray , I mentioned the where clause like this where clause = SID = EA1267D under that subproperty is output link = 4( Ihave given the output link number) This is for first fi...
- Mon Nov 19, 2007 12:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Using filter
- Replies: 9
- Views: 3596
Using filter
Hi All, I need to design a job which includes a filter ,in filter I need to filterout the incomming data and route it to three files by mentioning the different conditions(Ex emp no =10,emp no =20 ,and third one is reject rows. I did in this way in filter properties tab I mentioned the where clause ...
- Fri Nov 16, 2007 2:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: working with sequential file
- Replies: 3
- Views: 2220
Set the Final Delimiter property value to None. If you have only one link in the job, you will need to put some innocuous stage (such as a Copy stage) between the two Sequential File stages. ... Hi ray, I tried by putting none for the final delimeter option even I am getting the output with delimeter
- Fri Nov 16, 2007 12:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: working with sequential file
- Replies: 3
- Views: 2220
working with sequential file
Hi , I need to extract the data from a sequential file and load it into a target which is also a sequential file. The thing is source is a delimited file with first line as column names ,I can view the data in the source using "view data option" in the source stage. I want the target also ...
- Tue Nov 13, 2007 4:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date conversion
- Replies: 10
- Views: 5659
- Tue Nov 13, 2007 4:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date conversion
- Replies: 10
- Views: 5659
- Tue Nov 13, 2007 2:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date conversion
- Replies: 10
- Views: 5659
Date conversion
Hi,
In the source the format of date field is dd-mon-yy(ex : 29-apr-05).
I need to extract the month number from it .and apply some more functions on this field .(probably date functions) ,to apply date functions the format of the date must be dd-mm-yyyy. how to solve this.
In the source the format of date field is dd-mon-yy(ex : 29-apr-05).
I need to extract the month number from it .and apply some more functions on this field .(probably date functions) ,to apply date functions the format of the date must be dd-mm-yyyy. how to solve this.