Search found 6797 matches

by DSguru2B
Thu Mar 29, 2007 9:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem viewing a seq file on Datastage
Replies: 15
Views: 8704

My understanding is that the record length is telling the sequential file stage that the end of character has arrived, but infact it recieves a space. Look at the last field and its length. If thats ok then you need to work your way to the first column verifying each field honors the length specifie...
by DSguru2B
Thu Mar 29, 2007 9:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Wrapped stage error
Replies: 2
Views: 1193

Thats a user defined signal. See what it means by looking into the header file signal.h
by DSguru2B
Thu Mar 29, 2007 9:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: PX with Sequential File
Replies: 9
Views: 2496

How many nodes are you using? and on how many cpus? What about the disk utilization. A lot of factors involved.
by DSguru2B
Thu Mar 29, 2007 9:22 am
Forum: General
Topic: Link Count
Replies: 27
Views: 10932

:lol:
Due to popularity, we need a [sigh] icon.
by DSguru2B
Thu Mar 29, 2007 9:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequential File in EE
Replies: 5
Views: 1441

Great. You can mark your post as "Resolved" then. :)
by DSguru2B
Thu Mar 29, 2007 8:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to call teradata storeprocedure in datastage-px
Replies: 3
Views: 3015

You can always write a script, test it out from command line and invoke it from before/after job subroutines 'ExecSH' or a few other places.
by DSguru2B
Thu Mar 29, 2007 8:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Foreign Key Problem
Replies: 2
Views: 864

In order to capture the rejects, specify the constraint of the reject link as

Code: Select all

DBLINK.REJECTED

where DBLINK is the name of the link going to your odbc stage. Also make sure your array size is set to 1.
by DSguru2B
Thu Mar 29, 2007 7:57 am
Forum: General
Topic: Link Count
Replies: 27
Views: 10932

Search the forums. This information has been covered time and again with several different ways. Choose the best that suits your needs.
by DSguru2B
Thu Mar 29, 2007 7:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How Datasets are stored?
Replies: 12
Views: 3749

This post might be of interest to you.
by DSguru2B
Thu Mar 29, 2007 7:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Add Months to a Date
Replies: 9
Views: 6440

There is a similar Basic function by Ray on his home page, which works great. You can convert the logic to C code, with his permission offcourse.
by DSguru2B
Thu Mar 29, 2007 6:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to Concatenate Data from active stages in server 6.0
Replies: 5
Views: 1248

Go to job properties, in the Performance tab, uncheck Use Project Defaults, check Enable row buffer with option Inter process.
by DSguru2B
Wed Mar 28, 2007 6:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Server to Parallel Migration
Replies: 1
Views: 775

Search on key words like 'parallel migration'. Ray's class is going on this week. Check the home page. Its too late for the transition class. The registration for advanced classes is going on.
by DSguru2B
Wed Mar 28, 2007 2:55 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: string splitting
Replies: 15
Views: 3978

Anything huh...a hobbit, a chicken, anything. :lol:
by DSguru2B
Wed Mar 28, 2007 2:50 pm
Forum: General
Topic: SQL Server 2005 64bit ODBC Connection
Replies: 7
Views: 2909

Mostly databases are set up on static ports, atleast on all sites I have seen that use SQL Server. I am guessing its the same at your place too roy.
by DSguru2B
Wed Mar 28, 2007 1:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequential File in EE
Replies: 5
Views: 1441

No. It will read it one by one. For appending you need to join them. Do you have a key on both the files, on which the files will be joined?