Search found 53125 matches

by ray.wurlod
Tue Apr 30, 2013 2:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: configure the MainFrame Copybook Layout in Fast Track
Replies: 1
Views: 919

Convert the table definition imported from the copybook into a shared table definition in DataStage, then it should be visible in FastTrack. You will still need to add it to any FastTrack project in which you want to use it.
by ray.wurlod
Tue Apr 30, 2013 2:05 pm
Forum: General
Topic: Mulit-instance px job: seq invoc id missing
Replies: 3
Views: 927

Are you constructing the job name as an expression and somehow omitting the dot that separates base name from invocation ID?
by ray.wurlod
Tue Apr 30, 2013 2:04 pm
Forum: General
Topic: Issue with Multiple instance job seq
Replies: 5
Views: 1067

Use the -jobstatus option instead of the -wait option in your dsjob command.
by ray.wurlod
Tue Apr 30, 2013 2:00 pm
Forum: IBM QualityStage
Topic: Custom Rule Set Output Columns Missing
Replies: 2
Views: 2498

Might someone else have been playing with the dictionary file?
by ray.wurlod
Tue Apr 30, 2013 5:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORA-02291 Error in Oracle conector stage
Replies: 3
Views: 1761

What exactly does this error code mean?

Solve that, and you will solve your problem - don't do what is causing the error.
by ray.wurlod
Tue Apr 30, 2013 5:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: varchar to char issue in fixed length target sequential file
Replies: 1
Views: 1001

For a fixed-width format sequential file, the Null Field Value must have the same number of characters as is specfied as the field width.

And you should (can) not have VarChar data types in a fixed-width file.
by ray.wurlod
Tue Apr 30, 2013 5:40 am
Forum: General
Topic: Field Function in 8.5
Replies: 2
Views: 861

Welcome aboard. To solve this one you need to specify the last field number as the third argument of the Field() function. This is most easily found by counting the delimiter characters - and adding one if you want the very last field. Right(Field(lnk_read_gxm_src.agent, "/", Count(lnk_rea...
by ray.wurlod
Tue Apr 30, 2013 2:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: EBCDIC to VARCHAR - 2 bytes to 1 byte CHAR
Replies: 0
Views: 1780

There are no two-byte EBCDIC characters. It is a single-byte character set. Perhaps you need to review how your data are encoded.
by ray.wurlod
Mon Apr 29, 2013 8:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warning Message - Table not found
Replies: 10
Views: 2903

:oops:

Would you believe I once worked on a project where there was a source table called TARGET? Should've been SALES_TARGET, but I didn't have enough weaponry with me at the time to mount a convincing argument.
by ray.wurlod
Mon Apr 29, 2013 4:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warning Message - Table not found
Replies: 10
Views: 2903

How can you have records from the input if the table is missing? :?
by ray.wurlod
Mon Apr 29, 2013 4:19 pm
Forum: General
Topic: Telnet connection refused
Replies: 10
Views: 2177

There's usually a port number clash of some kind when you're on a Windows server. Try disabling the Windows telnet service, and making sure that the DataStage telnet service (dstelnet) is running. If that turns out to be the cure, configure one or the other to use some port other than 23. For exampl...
by ray.wurlod
Mon Apr 29, 2013 4:10 pm
Forum: General
Topic: How to migrate a DS-Basic Job from SERVER to PARALLEL?
Replies: 15
Views: 5922

You can use the profile of the credentialled user, the dsenv script, the global profile (/etc/profile) or you can use the DataStage and QualityStage Administrator client to create the environment variable for the project.
by ray.wurlod
Mon Apr 29, 2013 4:09 pm
Forum: Site/Forum
Topic: Premium Membership Activation
Replies: 18
Views: 23072

Please check directly with editor@dsxchange.com about whether your membership has indeed expired.
by ray.wurlod
Mon Apr 29, 2013 1:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Populate all rows in a single column
Replies: 4
Views: 1877

I didn't actually have to do any of that. DataStage took care of the line terminators while reading the file - the constraint expression did not pass any empty line.
by ray.wurlod
Mon Apr 29, 2013 1:56 am
Forum: General
Topic: How to find users login into one project
Replies: 3
Views: 1868

The first problem/question is whether each user has a separate Engine credential. If they do, then you might be able to inspect the admin lock on the project - either view locks using Cleanup Resources in Director client or issue LIST.READU command from the Administrator client Command window or wit...