DSXchange

Hi All, I need to call a stored procedure from a DataStage routine. I have written the following code: [/ $include UNIVERSE.INCLUDE ODBC.H ** PREPARE for DATABASE CONNECTION** status = SQLAllocEnv(HENV) status = SQLAllocConnect(HENV, HDBC) status = SQLConnect(HDBC, "RRTEDSS", "amar&qu...

Hi All, I am using DS.TOOLS to clear the status file. The Datastage director shows the status as COMPILED. But when i view the log, new log messages are logged indicating that the job is still running. Also I am unable to compile the jobe from designer and the message given is that this job is still...

How do I send mail to multiple recipients using DSSendMail. I am building my TO ADDRESS String as follows: strToAddress = "skaushik@abc.com" : " ; " : "nroy@abc.com" : " ; " : "vgupta@abc.com" : " ; " : "sghosh@xavient.com" But th...

Can any one suggest how to do start a job on an Event. I need to monitor a folder. When I get a file to process in that folder my job for processing that file should be invoked. I do not want time based scheduling where my job polls that folder and starts when it finds a file there. Thanks in advanc...

I need to use the READBLK routine of DataStage BASIC. My File size is of about 200 KB. What block size should I use to that I am abe to read the file at one shot. I am unable to read the file completely with block size 300000. Else what is the alternative to read the file of such size using READBLK....

I have 2 datastage jobs that insert in a single table. One job requires 4 columns as NOT NULL to get a unique record, while the other job needs only 2 columns of the same 4 column set to get an unique record. I cannot pass any default values in the 2nd job for the 2 columns for which I am not gettin...

Hi All, how can I prevent a datastage job from creating job log. Else I want that only the last 50 messages be stored in the job log and the rest get deleted automatically when a job runs. I need this information urgently as the job aborts if the log generated is very huge and the size of the log fi...

I need to do database access using BASIC routines. Can any one help
Thanks..
Nilotpal.

Hi All,
I would like to know how do I write Job APIs. Is there any documentation of these APIs. Can I invoke these APIs from subroutines.

Thanks and Regards,
Nilotpal.

Probably should do it in a controlling batch job that then runs your job. The batch could take in the filename as a parameter, execute the Unix command on the file, retreive the result and pass it to your job as another parameter. -craig Ya that is the logic.. but how do i retrieve the information....

Hi All, I need to retrieve the timestamp associated with a file on my Unix system. I am aware of the Unix command that will give me the timestamp. This command i can use with ExecSh Prejob routine. But How do I store the result of this command in a variable. Urgent help is needed. Thanks in advance....

Hi All,
How could I pass DSN name, User ID and Password to DS jobs(specifically ODBC stages). Or read a connection string having UserID, Password and DSN name so that these are not hardcoded in the stages.
Sample codes/references will be of great help.
Thanks in advance.
Nilotpal.

Hi All, While executing jobs with ODBC stages often I get the following 2 errors which I am unable to comprehend: 1)Invalid Cursor state. 2) SQL statement has incorrect number of result columns( this error occurs when I use a ODBC stage for Lookup) Please help me in understanding why these errors oc...

Hi All, I have 2 sequential files each having one set of values. I need to pick up one value from each set and construct a record to be inserted to the database. For example: File1 File2 ----- ----- valuei valuex valuej valuey valuek valuez So my 3 records will be : 1) valuei valuex 2) valuej valuey...