Search found 53125 matches

by ray.wurlod
Wed Dec 26, 2007 1:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SQL error for SQL Server.
Replies: 4
Views: 1420

For less than 30c per day you can have premium membership which, among other things, allows you to read the entire contents of premium posters' contributions. Premium membership revenue is 100% devoted to the hosting and bandwidth costs incurred by DSXchange; by purchasing premium membership you ar...
by ray.wurlod
Wed Dec 26, 2007 1:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: rtld 072-001 (xml input stage)
Replies: 1
Views: 651

Can you please post the exact error message? Don't transcribe - use copy/paste. The rtl part of the error message refers to "run time library" so I guess the error is being thrown by the XMLInput stage. But without the actual error message it's difficult to say more.
by ray.wurlod
Wed Dec 26, 2007 1:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FMT function logic in PX
Replies: 3
Views: 1474

Create a parallel routine that mimics some or all of the functionality of the Fmt() function - at least that subset that you require.

And stop thinking like a server job developer! Parallel jobs are a totally different product (formerly Orchestrate).
by ray.wurlod
Wed Dec 26, 2007 1:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: About a warning
Replies: 4
Views: 1473

Etiquette Note
Do try to specify a meaningful subject. It assists future searchers.
by ray.wurlod
Wed Dec 26, 2007 1:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: $APT_Config file changed
Replies: 2
Views: 939

You have not specified any disk pools.

You should always specify at least a default disk pool (the one with "" as its name). Otherwise there's a lot of use of /tmp that could be avoided. And /tmp typically is not large enough, particularly on Solaris.
by ray.wurlod
Wed Dec 26, 2007 1:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: VARCHAR converting to NVARCHAR
Replies: 9
Views: 4044

There is a pseudo-map called NONE. Might be worth trying that.
by ray.wurlod
Wed Dec 26, 2007 1:36 pm
Forum: General
Topic: Deleting header of Data file In UNIX
Replies: 7
Views: 1903

:idea:
Ask the COBOL developers to generate a file that lacks these headers and footers.
All they need to do is to comment out some statements.
by ray.wurlod
Wed Dec 26, 2007 1:34 pm
Forum: General
Topic: Creating ODBC Connection
Replies: 4
Views: 2117

The .odbc.ini file is usually located in the DataStage engine directory. It is (usually) also referred to by the ODBCINI environment variable. Therefore, if you execute the command echo $ODBCINI you would get the pathname of the .odbc.ini file. Edit the .odbc.ini file to set up the DSNs that DataSta...
by ray.wurlod
Wed Dec 26, 2007 1:31 pm
Forum: General
Topic: XML input stage
Replies: 2
Views: 801

Can you be a bit more precise about exactly how you are going about this, so that we don't have to read your mind? It's too difficult at this distance!
by ray.wurlod
Tue Dec 25, 2007 10:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cannot locate install.liborchoracle
Replies: 3
Views: 1478

Did you look on your installation media (the DVD or CD shipped from IBM)?
by ray.wurlod
Tue Dec 25, 2007 10:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SQL error for SQL Server.
Replies: 4
Views: 1420

The largest possible TinyInt is 127. Check the data type again. Select (outside of DataStage) the MAX value from this field. Try setting the Extended property of the field to Unsigned. That is, change the data type from TinyInt to Unsigned TinyInt (or from int8 to uint8). The largest possible uint8 ...
by ray.wurlod
Tue Dec 25, 2007 2:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with restarting DS Job Sequencer
Replies: 1
Views: 922

Examine the log entries for DS-SEQ1 in each case. There are entries pertaining to setting and clearing of checkpoints. Are these the same?

Recompiling will destroy checkpoints. Does MSTR-DS-SEQ "reset if required, then run" DS-SEQ1? If so, change the rules so that it only runs DS-SEQ1.
by ray.wurlod
Tue Dec 25, 2007 12:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Triming more than 1 spaces on a particular column
Replies: 12
Views: 2430

The unqualified Trim() function (see my earlier post) will remove all leading and trailing white space characters and reduce any internal multiple white space characters to single.
by ray.wurlod
Mon Dec 24, 2007 8:29 pm
Forum: IBM QualityStage
Topic: investigate stage
Replies: 23
Views: 10775

Why do you think that?
by ray.wurlod
Mon Dec 24, 2007 3:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Installation
Replies: 22
Views: 7290

Did you uninstall everything, including cleaning out the Registry, first?