Search found 53125 matches

by ray.wurlod
Thu Jan 25, 2007 3:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2 Bulk Load
Replies: 6
Views: 2186

Please post the complete and exact error text (double click in Director to retrieve it).

I am surprised to learn that any bulk load stage requires any output. In my experience they simply consume their input.
by ray.wurlod
Thu Jan 25, 2007 3:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to view dataset using Data Set Managment in Manager
Replies: 11
Views: 4370

A DataSet consists of two things: a control file, whose name ends in ".ds", which contains the record schema and the location of the actual data files one or more data files per partition, which reside on the resource disk for that node It is the former that you provide to the Data Set stage or the ...
by ray.wurlod
Thu Jan 25, 2007 3:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Processing multiple files
Replies: 11
Views: 3374

Does not the items list in a StartLoop activity support limited regular expressions?
by ray.wurlod
Thu Jan 25, 2007 3:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Use DSJOB to search in director log
Replies: 13
Views: 5943

Why not constrain -lognewest to type "control", which gives the event of the most recent job started event? Use this as the start timestamp for -logdetail or -logsum option. Then you can search that with grep.
by ray.wurlod
Thu Jan 25, 2007 3:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem providing path for Dataset
Replies: 4
Views: 896

If you can browse can you not select the pathname from the browser? Try using forward slashes in the pathname. Try using UNIX-style pathnames (that is, without the drive letter, and forward slashes - for example /Ascential/DataStage/Projects/MyProject/Controls/Cust.ds instead of C:\Ascential\DataSta...
by ray.wurlod
Thu Jan 25, 2007 3:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: IPC,LINK COLLECTOR
Replies: 3
Views: 1232

"Nodes" is a logical concept. Data are processed in parallel processes
by ray.wurlod
Thu Jan 25, 2007 3:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unkown result in the output of a routine which use SETFILE
Replies: 15
Views: 4682

Possible. In that case @SYSTEM.RETURN.CODE would return 0.
by ray.wurlod
Thu Jan 25, 2007 3:35 pm
Forum: General
Topic: Ds can handle variable record length COBOL file?
Replies: 3
Views: 1652

What stage type are you using? Have you imported the COBOL FD into the DataStage Repository? If so, please select the Layout tab in the table definition and post the record schema reported there.
by ray.wurlod
Thu Jan 25, 2007 3:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unkown result in the output of a routine which use SETFILE
Replies: 15
Views: 4682

That's a mystery. I could only ask "what's different between the two environments?" before attempting to essay an answer. My guess would be that "d:/ds/sam1/sample" exists in one environment and not in the other, and that they've changed how the test bed detects failure (so that my previous post is ...
by ray.wurlod
Thu Jan 25, 2007 3:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Issues with Sequences
Replies: 13
Views: 2393

That's one of the secrets of my success. :wink:

The Three Secrets of Success
1. see above
2. don't tell them everything you know
by ray.wurlod
Thu Jan 25, 2007 3:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: load data from MS Access DataBase to UDB by using DataStage
Replies: 13
Views: 5039

IS there an ODBC driver for MS Access on UNIX? :shock:
by ray.wurlod
Thu Jan 25, 2007 3:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Partitions in DataStage - DB2UDB
Replies: 2
Views: 847

Another possibility, if you have it, is to use a parallel job, in which the DB2/UDB Enterprise stage is intimately cognizant of the DB2 partitioning algorithm.
by ray.wurlod
Thu Jan 25, 2007 3:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Aborts abruptly after reaching 1000 records
Replies: 4
Views: 1219

Take a look at the "job starting" message in the log. Has the run limit been set to 1000 rows? If so, go to the Director client and click the Run tool again. In the Job Run Options dialog (where parameters are prompted for) select the Limits tab. What do you see there? Click Cancel so that the job d...
by ray.wurlod
Thu Jan 25, 2007 3:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: debugging Batch
Replies: 16
Views: 2751

OK, the problem is resolved. The DS manager missed to implement the routines in my project ! There is an opportunity that must be taken here. Implement a more systematic, and documented, mechanism for moving DataStage components between projects. You could have helped by recording the routines that...
by ray.wurlod
Thu Jan 25, 2007 3:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unkown result in the output of a routine which use SETFILE
Replies: 15
Views: 4682

The "test fails" for a very obscure reason, which you can ignore. Warning - Technical Content The test bed uses a system variable called @SYSTEM.RETURN.CODE to indicate success or failure. 0 is success. Query verbs (like COUNT) also use @SYSTEM.RETURN.CODE to transmit the number of records processed...