Search found 20 matches

by Django
Mon Aug 18, 2008 1:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Food for thought - Pivoting
Replies: 3
Views: 1663

Food for thought - Pivoting

Hello Ds Guruz I need help to pivot a seq. file with 2 columns to another seq. file with 2 columns. Input Sequential File ------------------ Name Score ------------------ Ramyt 1,2,3 Renai 5,6,7,8,9,10,345,122,456 Scott 345,67,23,1,8,4,45,89,23,78,90,100,60,23,12 Brian 23,45 etc The length of the sc...
by Django
Mon Aug 11, 2008 10:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: File Name property in Sequential File Stage
Replies: 14
Views: 25920

Resolve

Craig

Setting the APT_IMPORT_PATTERN_USES_FILESET to True resolved the issue.

Thx
by Django
Mon Aug 11, 2008 6:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: File Name property in Sequential File Stage
Replies: 14
Views: 25920

Any workaround ?

:( So whats the solution ?

If not through sequential stage properties is there any other way of reading the name of the files (of pattern *.txt) being used in the source stage.
by Django
Sun Aug 10, 2008 10:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: File Name property in Sequential File Stage
Replies: 14
Views: 25920

File Name property in Sequential File Stage

I have to read many .txt files from a directory and output to one single file. The output will be as follows ; First column is the name of the appropriate file and the remaining is the contents from each file. In the sequential stage I have set propertie -> Options -> File Name Column = 'FileNameCol...
by Django
Wed Aug 06, 2008 9:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading a .ini file
Replies: 1
Views: 1127

Reading a .ini file

Hello DS Djangos I'm sure I'll get the desired help here. I have got multiple .ini files sitting in the inbox folder. The format of the .ini files are [Section] Subject=Value Eg. [History Loading] ServerList=localhost1,localhost2,localhost3 [localhost1] Name=Brad Address=2 Winging [localhost2] Name=...