DSXchange

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...

Hi Andrw No, the directory does not get created. When I click "Add project" in administrator, the status bar tells copying files, then updating project indices , right at that moment, I get error updating secondary indices I did check the umask and strangely, it was 077 in the user profile...

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...

Thank You

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...

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...

I tried the same

echo "\n" > /usr/file.txt

the file when viewed has the characters
\n


i am on redhat linux. it works in command line. darn it.

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...

this is what enter in the command stage

echo
string"\n" > filename

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?

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...

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...

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...

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...

I can reply to #1 once I go on-site. I cant recollect right now.

Could someone clarify my other question #2 please