DSXchange

Hi all,

Can anybody suggest me how to call a unix script in the job sequence.
In the 1st job I am sending one databas table to a file.
Then I have to call an unix script to operate on that file.

Hi,

Actually I have not specified any fixed width size.
I have simply loaded the metadata from the database table while defining columns in the sequential file.
But while running the above mentioned error is showing.

Hi, I am getting the following error when sending a column from a database table to seq file. Sequential_File_12: When checking operator: When validating export schema: At field "file_processing_start_time": "null_field" length (0) must match field's fixed width (19) The mentione...

Under the before-after subroutines following 4 catagories are coming
1-DSJobReport
2-DSSenmail
3-DSWaitforfile
4-ExecSH
5-ExecSHSilent
6-ExexTCL

In the designer also we can choose any of the above only.
Then how to choose the DSSendMailTesterAttachment in the after subroutine.

Please suggest.

ok ray,

I gave the colon after attach still the attachment nt getting transferred.
The syntax is like this

From:jordery@abcd.com\nTo:pqr@abcd.com\nServer:smtp.ss.com\nAttach:/usr/ctg/dbacess.txt

any suggestions??

ray,
I have played with the precession and scale figures but I didnt get the result.
any idea??

Hi, Both my source and target is sequential file. For the source I have defined that partucular column as double and for the target I have defined that column as decimal. up to 4 th exponential it is working fine. Ray, Can you suggest me for more than 4th exponential what scentific notation I should...

Hi all, Please give me a solution regarding this. I have a file containg values as below real_daily_return -------------------- -5.41114562-e05 -4.98887625-e03 --------------------- I want to convert this data having double data type to data having decimal datatype. This works fine for those numbers...

I wants to attach a file in the DSSendmail post job routine. I have set the parameter as mentioned below. From:jordery@abcd.com\nTo:pqr@abcd.com\nServer:smtp.ss.com\nAttach:/usr/ctg/dbacess.txt Here the attached file dbacess.txt is not being transferred in the mail only a blank mail is transferred. ...

okay I got the out put. one issue regarding this I also wants to attach a file in the DSSendmail post job routine. I have set the parameter as mentioned below. From:jordery@abcd.com\nTo:pqr@abcd.com\nServer:smtp.ss.com\nAttach /usr/ctg/dbacess.txt Here the attached file dbacess.txt is not being tran...

Ok Brian,

Can you please send me the routine that will call a small routine that cats the file and reads its contents using DSExecute().

Hi,
You can take the option (d) (something else)from ray's given options..
Actually I want to assign values to the ENV from a job.
And that value will be reffered in the sequence job.
If without ENV my problem can be solved then please suggest.

Hi Craig,

About which path you are telling.
Please mention

Hi Wurlod, Sorry for late reply. Actually I want to pass values of some attributes to the enviornmental variable in a parallel job so that I can reffer these values in the sequence job to use in the email notification activity. So will you please tell me for this purpose how I have to add the envior...

Hi all,
Can anybody suggest me for what purpose schama files are used and how.