Search found 548 matches
- Tue Jun 17, 2008 1:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ORA-01017: invalid username/password: Logon denied
- Replies: 5
- Views: 6124
- Tue Jun 17, 2008 1:44 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading file with multiple header and trailer
- Replies: 1
- Views: 1850
Re: Reading file with multiple header and trailer
Header1 Det Records1 (Width 80) Trailer1 Header2 Det Records2 (Width 80) Trailer2 Header3 Det Records3 (Width 80) Trailer3 Read each line as one record into a column1 defined as varchar 200. Use a tranformer to sort the rows out into various links. you can build the logic inside transfomer that say...
- Tue Jun 17, 2008 1:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage admininstartion Presentations if any
- Replies: 4
- Views: 2848
Re: Datastage admininstartion Presentations if any
Never heard of this word.DSRajesh wrote:admininstartion
- Tue Jun 17, 2008 1:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Regarding EnvVariable
- Replies: 5
- Views: 3043
Re: Regarding EnvVariable
Is this what you are writing in after-job subroutine? or is it a part of the command?das_nirmalya wrote: 1;$<env_var>/
What does the above do?
- Tue Jun 17, 2008 1:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: fixed length file format/mapping
- Replies: 2
- Views: 2363
- Mon Jun 16, 2008 12:55 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to check the white spaces in a field of Char 40 Bytes
- Replies: 1
- Views: 2029
- Mon Jun 16, 2008 10:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: aggregator sort method issue
- Replies: 19
- Views: 21771
- Wed Jun 11, 2008 3:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading Fixed length record file
- Replies: 9
- Views: 6865
Re: How to read fixed width from a schema file
I want to know if we can read a fixed widht file using the schema file ..........my problem is i get data from different locations and the schema for each of them is different.......i want to read data from any source just by changing the schema file ....i could do that for a comma delimited file ....
- Wed Jun 11, 2008 3:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: APT_ParseError
- Replies: 6
- Views: 5839
- Wed Jun 11, 2008 2:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: executing a set of sql queries in a job
- Replies: 24
- Views: 10751
Re: executing a set of sql queries in a job
Is there a way that i can execute a set of sql queries from a single job. I mean i have the queries in a text file and i want to execute them on the oracle database. I can do that manually..but i want to create a job and keep it in the sequencer? i/p is file with queries and o/p stage should be dat...
- Wed Jun 11, 2008 2:49 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: executing a set of sql queries in a job
- Replies: 24
- Views: 10751
- Mon Jun 09, 2008 2:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading Fixed length record file
- Replies: 9
- Views: 6865
- Mon Jun 09, 2008 1:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading Fixed length record file
- Replies: 9
- Views: 6865
- Mon Jun 09, 2008 11:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: APT_ParseError
- Replies: 6
- Views: 5839
- Mon Jun 09, 2008 10:52 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Merge stage mapping error
- Replies: 3
- Views: 2335