Search found 312 matches

by Marley777
Tue May 04, 2004 12:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MAP_COVG_06,1: APT_DB2Query::fetch failed; code -290: SQL029
Replies: 6
Views: 2070

MAP_COVG_06,1: APT_DB2Query::fetch failed; code -290: SQL029

:oops:
Has anyone ever received this message? What did you do to fix the problem? We greatly appreciate you time and help.

MAP_COVG_06,1: APT_DB2Query::fetch failed; code -290: SQL0290N Table space access is not allowed. SQLSTATE=55039
by Marley777
Fri Apr 16, 2004 11:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Please help us figure out this DSR_JOB(Action=5) error!!!
Replies: 3
Views: 1909

Please help us figure out this DSR_JOB(Action=5) error!!!

Hello, I need help with a strange error I'm getting. I have searched the forum and found several references to (30107) related errors, but I never could find anything specifically related to the DSR_JOB(Action=5). I have paste the actual error below. Any help would be greatly appreciated. Thanks for...
by Marley777
Thu Apr 15, 2004 1:21 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Fixed Width Flat File Stage
Replies: 7
Views: 4279

All of this documentation is available on your Start Menu --> Ascential DataStage --> Online documentation. Look at Manager client documentation. :?: I did as you suggested and used the online manual. In DS Manager I go to Import=> Table definitions=> Sequential File Definitions => browse for my fi...
by Marley777
Thu Apr 15, 2004 11:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Fixed Width Flat File Stage
Replies: 7
Views: 4279

non delimited file

It's a check box in the sequential file stage. You should use the DS Manager client and walk thru importing metadata from the file. It has a preview button that will allow you to fiddle the settings and keep preview'ing until you get it right. :oops: I am also using a flat file that is not delimite...
by Marley777
Thu Apr 08, 2004 1:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Weird PX error when compiling!!!
Replies: 3
Views: 3625

Weird PX error when compiling!!!

Hello everyone, need help with a strange error. :oops: I keep getting the following error when compiling. "Cannot get exclusive access to executable file for job premdetail - job may be being monitored" We are positive this job isn't being monitored, in fact it's not running at all. We kil...
by Marley777
Tue Mar 09, 2004 7:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Tranform runs too long!
Replies: 5
Views: 5007

Tranform runs too long!

Please Help! :? Hello, I have a transformer problem and was wondering if anyone has experienced the same thing. I'm simply mapping my input to my ouput and creating an additional field based on the value of another field. I use an if statement in the derivation column of the new field to check the v...
by Marley777
Tue Mar 09, 2004 7:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Basic Tranformer Error Message
Replies: 4
Views: 4551

thanks

Hello Ray Wurlod,
thanks for answering the question we posted. We are looking into this with our UNIX ADM.
by Marley777
Mon Mar 08, 2004 2:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Basic Tranformer Error Message
Replies: 4
Views: 4551

Basic Tranformer Error Message

Hello, has anyone ever seen the following error? We are getting this error in our basic transformer stage.


'Received signal SIGBUS'

Thanks for your help!
by Marley777
Fri Mar 05, 2004 7:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Bring together 4 variable files into 1 file.
Replies: 3
Views: 3847

Thanks for the response! We simply need to concatenate variable length files into one big file. The big file will then go through a series of stages. It looks like all the stages require consistent META data for the input and outputs. I'm thinking that we can just run each file through it's own tran...
by Marley777
Thu Mar 04, 2004 7:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Bring together 4 variable files into 1 file.
Replies: 3
Views: 3847

Bring together 4 variable files into 1 file.

Hello, we are wondering if someone could guide us to a stage we can use to bring togther into 1 file, 4 variable files with different meta data for each file. In other words we want to create one big file with records from different files. Some files do have fields that are common with other files. ...
by Marley777
Mon Feb 02, 2004 10:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Setting global envioronment variables within Datastage Adm
Replies: 3
Views: 5923

Setting global envioronment variables within Datastage Adm

Hello, I'm new to the Datastage PX 7.0(UNIX), and I'm wondering if someone could give me some examples of ways you have utilized the envirionment variable within Datastage Adm. I realize global environment variables differ from project to project, and there are some common to all projects such as th...
by Marley777
Mon Feb 02, 2004 9:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Log
Replies: 8
Views: 3170

For Project wide auto purge 1) Bring up the DatatStage Administrator Window (if you have access) 2) Click Properties 3) On the General page select the (auto-purge of job log) check box 4) select the auto purge action you wish to take or for setting auto purge for a specific job 1) Bring up Datastage...