Search found 24 matches

by gangs
Tue Nov 30, 2010 6:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage (7.5x2) Sequential File Error
Replies: 3
Views: 4694

Just an additional piece of information for a different scenario I had... IIS 8.5 on Win Server 2003 Installation in C drive Projects created in E drive (there were space constraints) [/b] There was the same issue as mentioned in the originating post... main_program: File archive: Trouble creating f...
by gangs
Thu Jun 11, 2009 7:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Passing Arguments to C++ routines
Replies: 5
Views: 2827

Passing Arguments to C++ routines

specified but not used in flow: DSPXWorkingDir ##E IIS-DSEE-TBLD-00076 19:02:28(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 24,576. ##E IIS-DSEE-TFSR-00019 19:02:28(001) <main_program> Could not check all operators because of previous error(...
by gangs
Thu Jun 11, 2009 7:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Passing Arguments to C++ routines
Replies: 5
Views: 2827

Passing Arguments to C++ routines

thanks for reply actually i created c++ routine just to return 0 without passing arguments and i called in ds ,,,it is working fine now i a want to write another c or cpp program which accepts arguments suppose additon of two numbers ..i want to give at run time i am able to create dot obj file , do...
by gangs
Thu Jun 11, 2009 7:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Passing Arguments to C++ routines
Replies: 5
Views: 2827

Passing Arguments to C++ routines

how to pass arguments to C++ routine

i have create *.O file i used it in PX routine
now i want to pass arguments to routine
by gangs
Mon Jun 08, 2009 6:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to Create C++ Routine in Datastage PX
Replies: 3
Views: 10058

How to Create C++ Routine in Datastage PX

can anyone explain How to Create C++ Routine in Datastage PX in steps
i am using datastage 8.01 Version

Thanks in Advance..
by gangs
Mon Jun 08, 2009 6:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Creating C++ routine in Datastage PX
Replies: 1
Views: 1651

Creating C++ routine in Datastage PX

While compiling C++ routine Job we are getting below error,can anyone help on this ##W IIS-DSEE-TFTM-00012 17:13:18(002) <transform> Error when checking composite operator: The number of reject datasets "0" is less than the number of input datasets "1". ##I IIS-DSEE-TBLD-00000 17...
by gangs
Thu Nov 27, 2008 6:38 pm
Forum: General
Topic: Slow compilation issue
Replies: 0
Views: 1027

Slow compilation issue

I had an issue with compiling certain jobs. Some of these jobs were executed without issues as late as a couple of days back in the same environment. The only issues noted in between was bad server performance (overall server) because of load on the server. Currently am not able to compile certain j...
by gangs
Thu Jun 05, 2008 11:07 am
Forum: General
Topic: Query filter in DRS fails weird
Replies: 0
Views: 944

Query filter in DRS fails weird

The issue is very strange. I have a type 2 handling job (no data transformations other then identifying delta and ins/upd appropriately). At the end of the flow are two DRS stages to same table - one to insert new rows and the other to update old rows as expired (dates and record inds). this is the ...
by gangs
Sat Mar 29, 2008 4:21 am
Forum: General
Topic: Program ....: Line 810, Improper data type.
Replies: 3
Views: 2324

Thanks so much for throwing light on the job file & RT_BP folder. I was able to go to the line and find out the expression causing the issue. There was data in one of the cols involved in the expression that had nulls. Thanks and I got to know about this error & RT_BP folders.
by gangs
Thu Mar 27, 2008 7:33 am
Forum: General
Topic: Program ....: Line 810, Improper data type.
Replies: 3
Views: 2324

Program ....: Line 810, Improper data type.

I have a server job that reads from a sequential file. There is just one transformer with lookups from 3-4 tables (thro DRS stage) and 2-3 hash files. The job constantly aborts with the following abort message DataStage Job 6074 Phantom 7960 Program "JOB.554786582.DT.1469725302.TRANS1": Li...
by gangs
Mon Nov 26, 2007 12:41 pm
Forum: General
Topic: Issue in reading Hash file data
Replies: 3
Views: 2283

Thaks Ray. I wasnt able to view the complete response but it helped. I worked on those lines and tried importing the hashed file's table defn. It didnt show up correctly the changes after I re-created with new key defn and was still showing the older defn. I then did this - checked the option 'Delet...
by gangs
Tue Nov 20, 2007 9:54 pm
Forum: General
Topic: Issue in reading Hash file data
Replies: 3
Views: 2283

Issue in reading Hash file data

I encounter a weird behaviour while reading data from a hash file. This is the exact field layout in the hash file counter integer col1 char col2 char col3 smallint col4 smallint col5 char col6 timestamp col7 timestamp There is a code in routine/ job control that reads data like 'SELECT * FROM HASH ...
by gangs
Mon Nov 19, 2007 2:34 pm
Forum: General
Topic: Server job in running state
Replies: 6
Views: 3036

Sorry for the trouble and it was my bad. I was trying to change something in the existing batch job which runs a counter variable called Pointer starting from 1. I wanted to assign it an initial value from a hash file column and had used this piece of code. PointerCmd = "SELECT <col name> FROM ...
by gangs
Mon Nov 19, 2007 1:45 pm
Forum: General
Topic: Server job in running state
Replies: 6
Views: 3036

I've had instances where my co-developers also have reported the same problems with the jobs. I could remember a couple of occasions when I've faced the problem, it was a Batch job.
by gangs
Mon Nov 19, 2007 11:59 am
Forum: General
Topic: Server job in running state
Replies: 6
Views: 3036

No, there is no before-job routine in the job.