Search found 53125 matches

by ray.wurlod
Tue Mar 18, 2008 5:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem in installing DataStage ver5.2 Package (Plugins)
Replies: 4
Views: 1211

Try /opt/ds/packages/ftp, or drill down into the dstage directory to look for something one level further down.

May I ask why you are installing such an old, and no-longer-supported, version?
by ray.wurlod
Tue Mar 18, 2008 12:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: scheduling 2parall jobs wit surogatekey 2 run at same time
Replies: 5
Views: 1428

OK then, if it's not privileges, it's something in the database preventing one of the jobs from creating a new value in the sequence - get your DBA to help - this problem would probably occur if two simultaneous non-DataStage clients were also trying to use the same sequence.
by ray.wurlod
Tue Mar 18, 2008 12:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error in Importing a job
Replies: 1
Views: 753

Your Windows code page is currently set to 874 (a Thai character map based on TIS620) but the code page of the machine that exported the DataStage components was set to 1252 at the time. To allow the import to occur, edit the DSX file and change the CharacterSet line so that it reads "PC874" (or, ma...
by ray.wurlod
Mon Mar 17, 2008 7:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Link Count
Replies: 22
Views: 6577

I don't need anything from it. You do. You use the Field() function and substring techniques to extract the various pieces. The delimiter character between lines is the system variable @FM.
by ray.wurlod
Mon Mar 17, 2008 7:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete file after FTP
Replies: 48
Views: 8030

Script.
by ray.wurlod
Mon Mar 17, 2008 5:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Link Count
Replies: 22
Views: 6577

Use a directory to which the executing user has read, write and execute permission.
by ray.wurlod
Mon Mar 17, 2008 5:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dsjob return 255
Replies: 5
Views: 6037

-param is the correct option, not -parm
by ray.wurlod
Mon Mar 17, 2008 4:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MKS Installation Error
Replies: 6
Views: 1721

Yes, uninstall everything. Then install the .NET C++ compiler. Then install DataStage, licensing both server and parallel jobs. MKS Toolkit should automatically install.
by ray.wurlod
Mon Mar 17, 2008 4:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fatal Error: An ORCHESTRATE program must be started on a nod
Replies: 3
Views: 4835

Is PXEngine visible (copied to or mounted on) all nodes mentioned in your configuration file?
by ray.wurlod
Mon Mar 17, 2008 4:54 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Retrieving mismatches real-time
Replies: 1
Views: 602

Almost certainly yes.
by ray.wurlod
Mon Mar 17, 2008 4:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC stage Metadata Issue for Bigint data type
Replies: 6
Views: 1247

It comes with DB2 client software. It's not part of DataStage.
by ray.wurlod
Mon Mar 17, 2008 4:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: scheduling 2parall jobs wit surogatekey 2 run at same time
Replies: 5
Views: 1428

Looks like you lack privilege to use the schema name SYSTEM. Try using a more appropriate schema (owner) name.
by ray.wurlod
Mon Mar 17, 2008 4:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to extract Pipe delimiter files...
Replies: 2
Views: 787

Use the pipe character ("|") as the field delimiter in the Format properties.
by ray.wurlod
Mon Mar 17, 2008 4:47 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete file after FTP
Replies: 48
Views: 8030

Your wonderful invisible friend again? Port 23 (the telnet port) is one of the ones that is typically disabled when a site is "secured" and, yes, this means that port 22 (SSH - the "secure" equivalent of telnet) is the appropriate protocol to use. But, as Craig asks, why are you trying to telnet to ...
by ray.wurlod
Mon Mar 17, 2008 4:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Fatal error
Replies: 9
Views: 1834

NEVER delete RT_LOGxxxx using operating system commands - it is a hashed file, and deleting it improperly will leave the repository database in an inconsistent state. When you delete a job, there are several other hashed files that also need to be deleted; the only correct way is to delete the job ...