DSXchange

Your engine is apparantly not able to find a dll file which it needs. Is this a new installation, or the jobs suddenly starting aborting with this error?

Ofcourse there is. You will have to spit out the entire log file to a text file and then use your unix scripting skills to parse through the log file to get all the information you need.

Look at the code of sdk routine, under Utility, UtilityRunJob(). It shows you how to get the jobstatus after running a job using DSRunJob()

Craig and Ray have already replied to your quest. Use the cat command in the before job subroutine 'ExecSH' to concatenate all the files you want to concatenate and redirect it to a different file. Use this file inside you job. cat file1 file2 file3 > fileAll where file1, file2, file3 and fileAll sh...

sjordery wrote:link = DSGetLinkInfo(test_job, "Transformer_2","DSLink4",DSJ.LINKROWCOUNT)

Thats a DataStage API function. It will not work at the OS level. Read about DSGetLinkInfo in DataStage help.
Search the archives on how to use it in a basic batch job or routine.

Search on the error message. I remember going through this ordeal myself. It has been discussed in detail.

Why dont you start by telling us how you set up your job?
Did you provide the correct lengths of each field under the column's tab in the sequential file stage?

A small correction here. NullToValue() will work only in the transformer stage. It wont in the modify stage. There is a mistake in the parallel guide. Use handle_null(). Search on the name for its exact syntax.

In server there are no datatypes internally, they are all stored as characters. So if you mean you want to extract numbers from an alphanumeric string then you can use OCONV with MCN conversion code. If you mean something else then please explain.

Having nil experience on windoze box, I would say, 'check with your system admin'. I bet your not the first person who is having scheduling problems on your box. Others might have encountered the same phenomenon. Your SA should be able to advise a workaround/solution.

That might be it. Remove the + sign using the CONVERT() function and then try. If the error goes away then that was it, else more investigation is needed.

Same thing can also be done in a px transformer. StringToTimestamp() and TimestampToString() functions, I believe, in the transformer. You can find the complete list under Transforms, under Type Conversion when you right click on the extended derivation window.

Are you using user defined query? Make sure you have no new line after the last line in your sql. Also check there is nothing (not even a space) in the before/after sql tab or OPEN/CLOSE options.

Re-import the table definition. Something must have changed between the time you imported the table definition and when you ran this job. If that does not help then you pretty much have to go through all the columns manually and check its size.

I think its about time we have an "Interview Questions" forum out there, just for the heck of it. This is the only area that seems to be all over the place. We can call this forum Leecher's Hot Spot, or maybe thats too harsh