Search found 15603 matches

by ArndW
Tue Jun 30, 2009 4:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error runing Version 8 job from unix script
Replies: 4
Views: 1292

the path to programs is in /bin, not /lib
by ArndW
Tue Jun 30, 2009 4:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SLEEP function clarification
Replies: 8
Views: 2384

I had issues with the DataStage SLEEP function several years ago with V7, it would usually function but sometimes, for no immediately obvious reason, stop working. I recall having opened up a call with support at the time, but as a sporadic problem it was almost impossible to track down. We modified...
by ArndW
Tue Jun 30, 2009 4:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Send Mail for warning Rows
Replies: 25
Views: 6025

"Sort" is not a valid UNIX command. "sort" should work.
by ArndW
Tue Jun 30, 2009 4:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Importing Routines.
Replies: 5
Views: 1265

Edit the .dsx and change the name of a routine, then try to import. Do you get an error message or did that function correctly? It would seem that you have "read only" markings in your project.
by ArndW
Tue Jun 30, 2009 4:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Update Environemt Variables
Replies: 17
Views: 5266

Typically that error comes when the object code isn't linked correctly, and/or when the function definition doesn't match the code. Specifically: - declare it as an object - declare it with 3 arguments of char* - declare it with a char* return type - declare it with "external subroutine name&qu...
by ArndW
Tue Jun 30, 2009 4:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Oracle EE stage
Replies: 12
Views: 2255

In that case, what happens when you install the 10g version?
by ArndW
Tue Jun 30, 2009 4:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: COUNT OF RECORDS
Replies: 3
Views: 1068

It depends upon what you want to do with that count. Since the end-of-file marker comes after the last row you cannot use a transform stage to output a single row containing the number of input rows - you need to use an aggregator to do this. There are methods that you can use to get the row count -...
by ArndW
Tue Jun 30, 2009 3:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Migration from 7.0 to 8.x
Replies: 2
Views: 864

The server functionality of Version 7.x remains with PX Version 8.x and any jobs should continue to function in the same manner as before. You will have new functionality at V8 as well as a somewhat more complicated installation and administration using the Websphere components and you should try to...
by ArndW
Tue Jun 30, 2009 3:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Oracle EE stage
Replies: 12
Views: 2255

Are you using MQ Series at all? If not, it won't make a difference which stage you install. Just use "client". If you have Oracle 9i in use then install the 9i Oracle plugin.
by ArndW
Tue Jun 30, 2009 3:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: not able to create new project
Replies: 27
Views: 8187

This means that the fixtool will be incapable of fixing all the errors in the file. I think that you are SOL in this case. The problem with the UV_SCHEMA file is that you can't play around with it they way you can with other hashed files, so the usual methods (i.e. copying contents, deleting, re-cre...
by ArndW
Mon Jun 29, 2009 9:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Can't shutdown DataStage server as 'dsadm' user
Replies: 7
Views: 4705

What happens when you just execute "./bin/uv" from the $DSHOME directory? (use "QUIT" to exit TCL if successful). What happens if you copy the "uv" executable and, with 777 permissions to the copy, execute it?
by ArndW
Mon Jun 29, 2009 9:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error while reading environment variable
Replies: 13
Views: 4419

Lol - I should have done that as well. Thanks.
by ArndW
Mon Jun 29, 2009 8:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Creating New Project
Replies: 5
Views: 1540

Can you create a project with a different name in a different location? If so, then chances are that something went wrong in an earlier attempt to create that project.
by ArndW
Mon Jun 29, 2009 8:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abnormal termination of stage -Transformer
Replies: 19
Views: 7325

Replace the Oracle output with a sequential file stage. Does the error go away?
by ArndW
Mon Jun 29, 2009 8:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSD.BCIPut call to OCONV failed
Replies: 21
Views: 6378

Can you identify which column is causing the error? (remove columns one-by-one until the error goes away). The "BCI.PUT" call is not done in the transform stage - are you sure that this error is being caused there?