Search found 42189 matches

by chulett
Tue May 26, 2015 7:47 pm
Forum: General
Topic: Reading a File & using the column value as parm for next
Replies: 5
Views: 1598

All kinds of ways to skin this cat, as they say. :wink:
by chulett
Tue May 26, 2015 5:15 pm
Forum: General
Topic: Reading a File & using the column value as parm for next
Replies: 5
Views: 1598

Typically the next question would be "How do I build the list of filenames?" and the typical answer there would be to use a User Variables Activity stage to execute a UNIX command to list the files. From what I recall, the "ls -m <pattern>" option would create a comma delimited l...
by chulett
Tue May 26, 2015 12:12 pm
Forum: General
Topic: Reading a File & using the column value as parm for next
Replies: 5
Views: 1598

What you are looking for is a looping Sequence job. The Sequence job would leverage the Start Loop and End Loop stages to iterate through a delimited "list of things" and in this case your list would be a list of filenames. Inside the loop would be your file processing job and it would be ...
by chulett
Tue May 26, 2015 9:50 am
Forum: General
Topic: Can't install DS 7.5
Replies: 5
Views: 1331

So all you had to do was wait three days for that last one percent? 8)
by chulett
Tue May 26, 2015 9:49 am
Forum: General
Topic: FoxPro Server file issue
Replies: 8
Views: 2842

See if this helps: connect to the dbc. If it doesn't, run more searches for your error message. Worst case involve support.
by chulett
Tue May 26, 2015 8:55 am
Forum: General
Topic: Default location of file creation
Replies: 4
Views: 912

AKA the Current Working Directory for a running job. AKA not a good place to put them.
by chulett
Tue May 26, 2015 6:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel job reports failure (code 720907)
Replies: 4
Views: 2952

Found this support technote that mentions your error, are you on AIX by chance?
by chulett
Tue May 26, 2015 6:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel job reports failure (code 720907)
Replies: 4
Views: 2952

No idea but... how large is this 'entire record'?
by chulett
Tue May 26, 2015 6:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Complex flatfile warning
Replies: 5
Views: 2672

Now it is working... because you did what to correct it? :?
by chulett
Tue May 26, 2015 6:42 am
Forum: General
Topic: FoxPro Server file issue
Replies: 8
Views: 2842

It's been years since I've worked with dbf files, so no... other than to suggest you take a closer look at the 7 that work and the 8 that don't and compare them. Something is obviously different between them.
by chulett
Tue May 26, 2015 6:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: [IBM][CLI Driver] CLI0143E Invalid precision value
Replies: 7
Views: 6146

That's too bad as it means we don't have that diagnostic information. If the other information that Ray and I posted don't help, involve your official support provider.
by chulett
Sun May 24, 2015 1:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Set the value of a Variable using a Variable
Replies: 5
Views: 1519

In your example? Never, I'm afraid.

vReference will change in value when you change it, when you assign it a new value. And that can only happen in its own derivation.
by chulett
Sun May 24, 2015 12:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Blank Rows are not Read by Datastage
Replies: 4
Views: 1494

Not neglected but rather rejected since they did not match the metadata. They can either be captured via a reject link and processed separately or in your case you should check into the "Reject Mode" property of the stage, see if one there would help with this.
by chulett
Sun May 24, 2015 8:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: datastage requirement?
Replies: 2
Views: 1559

:idea: The Parallel Job Developer's Guide has an excellent appendix listing the functions available, including one for returning the "day of week" from any date. Give it a look when you have questions like this.
by chulett
Sun May 24, 2015 7:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Set all Blank Files to Null
Replies: 1
Views: 799

So not really blank "files". And isn't this the same problem / question as you posted here?