Search found 53125 matches

by ray.wurlod
Thu May 11, 2006 2:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error using Basic Transformer
Replies: 6
Views: 2273

When you searched the forum, you would have found that -14 usually means that your server is overloaded. You would also have found a number of remediation measures.
by ray.wurlod
Thu May 11, 2006 2:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2 Enterpirse Stage use /tmp directory to making temp file
Replies: 7
Views: 2932

Is there a property in the DB2 Enterprise stage that allows you to set the temporary directory? Or a DB2 environment variable?
by ray.wurlod
Thu May 11, 2006 2:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Decimal conversion warning
Replies: 6
Views: 2119

Are you using a BASIC Transformer stage or a Parallel Transformer stage?
by ray.wurlod
Thu May 11, 2006 2:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle_Enterprise_28,0: Failure during execution of operator
Replies: 1
Views: 976

Somewhere there's a time that's not in a valid time format. Based on the information you have provided that is all the diagnosis possible. If you have more information you could post it. Otherwise you can do some detective work with your data. Insert some Peek stages so you can figure out what's hap...
by ray.wurlod
Thu May 11, 2006 12:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Loading multiple files in a single job.
Replies: 10
Views: 4603

Or use cat file1 file2 file3 as the filter in a Sequential File stage (which uses stdout of the cat command as its source)?
by ray.wurlod
Thu May 11, 2006 12:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ORA-01036: illegal variable name/number
Replies: 6
Views: 2150

You have four columns in your job, but only three parameter markers in the SQL. It is this about which the complaint is being made. There is a fourth variable, but it is not bound to any parameter marker.
by ray.wurlod
Thu May 11, 2006 12:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastge with windows operating system?
Replies: 6
Views: 3277

DataStage will not install on Windows XP Home (I guess that's the import of your question). From version 7.5 DataStage server will not install on Windows NT 4.0. Versions 7.1 and earlier will so install. DataStage server will install and work on Windows 2000 Server or Windows 2003 Server. To run par...
by ray.wurlod
Thu May 11, 2006 12:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Restarting a job with the same parameters
Replies: 15
Views: 4792

Well, it's not strongly encrypted, you could decrypt it. :twisted:
by ray.wurlod
Thu May 11, 2006 12:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DELETE NEWLINE
Replies: 6
Views: 2281

Something like

Code: Select all

If Index(Inlink.TheRecord."New",1) > 0 Then Ereplace(InLink.TheRecord, "New":Char(10), "New", -1, 0) Else InLink.TheRecord
by ray.wurlod
Thu May 11, 2006 12:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: LD_LIBRARY_PATH
Replies: 3
Views: 989

When you run a job the actual environment variable settings are in the second event logged. Did you check there?
by ray.wurlod
Thu May 11, 2006 12:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Version Control
Replies: 9
Views: 1925

Recompilation is actually optional. However, all run time components must be present on all platforms.
by ray.wurlod
Thu May 11, 2006 12:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Number Of Stage Variables
Replies: 2
Views: 1462

Welcome aboard. :D

You are correct, there is no limit.
by ray.wurlod
Wed May 10, 2006 3:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequencer
Replies: 14
Views: 4929

There is a new activity called the User Variables activity on your Palette. Check it out! I think you will like it. 8)
by ray.wurlod
Wed May 10, 2006 3:06 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Call .exe file thru DataStage
Replies: 10
Views: 5557

Try using the DOS start command to execute your BAT file. This starts a separate window to run the command.
by ray.wurlod
Wed May 10, 2006 3:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash File Date Format
Replies: 3
Views: 1190

When the hashed file was created for whatever reason the default date format was set to a two-digit year. You can either re-create the hashed file or adapt its file dictionary. Change the conversion field from D2... to D4... for example.