Search found 91 matches
- Wed Jul 30, 2008 10:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: error updating secondary indicies
- Replies: 5
- Views: 4044
I am not getting response from IBM support. I was wrong. It is creating the project directory with all the regular files inside it. I also checked the UV.SCHEMA, it looks good. However, for UV_ACCOUNT, I see the regular entries except for the OWNER. The OWNER value is blank for the project I am tryi...
- Wed Jul 30, 2008 11:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: error updating secondary indicies
- Replies: 5
- Views: 4044
- Tue Jul 29, 2008 4:18 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: error updating secondary indicies
- Replies: 5
- Views: 4044
error updating secondary indicies
hello I got my datastage project corrupted when I was creating it through administrator and lost network connection. When I tried to delete it through administrator, it would not let me saying, "account does not appear to be datastage project". I was able to create a brand new project with...
- Wed Apr 18, 2007 8:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: column names with "$" character
- Replies: 6
- Views: 4141
- Wed Apr 18, 2007 8:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: column names with "$" character
- Replies: 6
- Views: 4141
column names with "$" character
I have a simple job that reads an as400 table using ODBC and writes to an oracle table using DRS stage. Both the table names have column names with $ character in them. While reading I was able to use user-defined and create alias using zxc$b AS zxcb and while writing, I pass it through a transforme...
- Thu Jul 13, 2006 9:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: node_node3:partition 0 of 1 on node 3 terminated unexpectdly
- Replies: 3
- Views: 2440
node_node3:partition 0 of 1 on node 3 terminated unexpectdly
etl server is a cluster of two system with each configured as two nodes in datastage. Only one job aborts which reads from a sequential file and loads to four different tables on sql server the error message i get is failure during execution of operator logic and node_node3:player1 terminated unexpe...
- Mon Jul 10, 2006 9:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: newline in command stage
- Replies: 8
- Views: 4987
- Mon Jul 10, 2006 8:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: newline in command stage
- Replies: 8
- Views: 4987
I tried everything but no success. (1)\n with no quotes around and also with quotes around (2)quotes around string and newline together even tried putting the entire command in command field with no parameters as suggested, still the same. the log clearly shows that the output of command as literall...
- Sat Jul 08, 2006 7:44 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: newline in command stage
- Replies: 8
- Views: 4987
- Sat Jul 08, 2006 7:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: newline in command stage
- Replies: 8
- Views: 4987
newline in command stage
Trying to use a command stage to write data to a file
command being used is "echo "
and parameter is string"\n" > filename
The same command works in unix.
what am i missing?
command being used is "echo "
and parameter is string"\n" > filename
The same command works in unix.
what am i missing?
- Wed Jun 28, 2006 9:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: aborted and aborted/restartable
- Replies: 3
- Views: 2595
Because I want my script to handle scenario where one sequencer is restartable and the other sequencer is not. when I kick off an aborted non-restartable sequencer, it would return you an error saying job is not in runnable status. one would to go to director and reset it. I am looking for an answer...
- Wed Jun 28, 2006 9:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: aborted and aborted/restartable
- Replies: 3
- Views: 2595
aborted and aborted/restartable
Both 'aborted' and 'aborted/restartable' have the same job status which is 3. How can I determine when to reset and when not to reset the sequencer if I am going to call the sequencer from a unix script? I am ending up resetting the sequencer when sequencer is in aborted/restartable status. I was no...
- Wed May 31, 2006 10:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: odbc stage server -parallel calling stored procedure
- Replies: 4
- Views: 4225
The procedure is run in an ODBC stage in both server and parallel, the proc would return a result set. In server job, when I call procedure in sybase the syntax is '{call procname};' //runs fine In parallel job(ODBC->dataset) the syntax being '{call procname};' or 'execute procname' and sql being be...
- Mon May 29, 2006 8:35 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Generate multiple records from a single source record
- Replies: 3
- Views: 1768
You said based on the source column. More info would be helpful in understanding what you looking for. If your input columns are more than two, using a pivot stage you can build multiple records from a single record . Please check pivot doc for more information. Here is an eg: A record with four col...
- Sun May 28, 2006 3:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: odbc stage server -parallel calling stored procedure
- Replies: 4
- Views: 4225