DSXchange

Neither of these servers are running a unix environment. The command stage seems to execute the script, it will output the contents of the script in director, but nothing seems to happen on the remote server.

I've been tasked with creating a job that simply executes 2 dos batch jobs. The jobs must reside on a specific server. Can the Command Stage execute these jobs on the different server?

Thanks Ray! You sir are a genius!

thanks..I did just that...just waiting for them to get back to me.

We have a few jobs that connect directly to Oracle. Since we applied the DST patches to the Datastage server yesterday, these jobs have failed. We receive two different error messages. They are as follows: SQLSTATE=IM003, DBMS.CODE=160 [DataStage][SQL Client][ODBC]Specified driver could not be loade...

Thanks!! I was looking into that when you replied! It certainly did the job. Thanks again!

So we've just found out we have production jobs scheduled to in the development on our datastage server. They have been running properly since at least 2004. (way before I got here). I moved the first into production and received the error below. Can anyone provide me with any advice? From previous ...

Before I posted this I actually did a search for the actual abort message and gave me different results. But thanks for the link

I'm trying to implement A job that uses the SQL Server Bulk load. I'm receiving the following warning and abort, respectively. BulkLoad.gn_fd_currency: Internal error: Failed to IRowsetFastLoad interface. BulkLoad.gn_fd_currency: Failed to prepare fast load session. any help on this issue would be g...

I have the following piece of code setup to read the 'DSSendMail 'To:' parameter from the TEST_Email_Control.txt file. The contents of said file are: To:abc@xyz.com\n My question is: Can you designate multiple email addresses in the 'To:' parameter? EMail = '' * Find out what AS/400 the file will be...

You're a genius! Thanks. after all that, it was one line of code!

I've tried different variations of GoTos and also tried arrays, but just can't seem to figure this one out.

I'm trying to create the content for an email from a text file. The email contains an output from an SQL statement. The statement returns multiple rows. In the actual email only the last line from the file is displayed. The code is as follows: Reportdate = OConv(@DATE-1, "D-DMY[,A3,]") Lin...

I have the following code: message = message:char(10):JobName:"|":messagebody:"|":StartTime OPENSEQ "G:\DataStage\Incoming\jeff.txt" TO FILE ELSE CREATE FILE ELSE ABORT WEOFSEQ FILE WRITESEQ message TO FILE ELSE STOP The message is the job name, last run status and star...

People join this web because it is free and is an incredible resource. It has proven invaluable on a number of occasions. By that incredibly simple logic, I shouldn't complain about $50. But keep in mind that this is the cost for the first year. After the first year the price doubles. Who knows wher...