DSXchange

Use the Matches operator. Something like if in.Col Matches "12N.2N" then "A" else if in.Col Matches "15N.2N" then "B" else "C" Do the above in a stage variable. For Decimal(12,2) the stage variable will evalute to A. Similarly for Decimal(15,2) it wi...

DataDirect ODBC drivers expire after 30 days when used outside of database stage. They need to be purchases explicitly. If you tell us what needs to be done, I bet someone here can give you a proper way of doing it. What your client is requesting is not the right way unless there is some information...

Reset the job. See if your getting any additional error messages. Also, try re-running the job. Does it occur everytime you run the job?

That might be it. It might be enforcing the NLS on that particular schema.

Sounds like you need to set the env. var. NLS_LANG to whatever is in your database.

If your greping for a value that will be passed in as Arg1 then should'nt your command look something like

Even if you build it by burning a lot of brain cells, the usage option will expire after 30 days. Unless you decide to buy it from DataDirect. Whats wrong in using the sequential file stage?

You should be able to get the manuals from the AutoSys team.

Why not parametrize these strings?

Read ray.wurlord's first reply here.He mentiones about Basic API's to connect to database using odbc connection.

If your not well versed in writing routines then I would suggest a workaround. Call the stord proc. in a before/after sql tab of DRS stage or from STP stage. You dont need to write a custom routine to do this.

It depends upon how your kernal is set up. Ideally, it should invoke the second processor. To get a better understanding of this, I suggest you sit with your SA and ask him/her at the OS level how processes are managed.

Can you edit anything in this job? Try changing the link name to something, maybe a meaningful name and try to save it first and then try compiling.

Do an exact search on the error message. You will find quite a few posts related to this error.

If your data is quoted then provide the quote character. This will pick up the data as you want. Since it is a csv file. With quote character set to none, each comma will be treated as a selimiter.