DSXchange

Its a C routine so you will need to copy the routine in the embeded post. Compile it using the C compiler which you should have as the transformer works only with a valid C compiler installed. Once you compile your routine(.c) it will create an object file referred to with a dot o extrension (.o). C...

I doubt there is such an option. But you need to re-think your approach. Don't let warnings occur in the first place. Treat all warnings as reg signals. If warnings are more like informational messages then demote them as one, using the message handler. But with warnings such as resource constraints...

Look in the log file of both the jobs (the job that created this dataset and the load job). Look at the 5th or 6th entry I believe, the entry will start with the line 'main_program: APT configuration file: '.

How are you getting the Current Timestamp? What is the length of your target stage?

How many nodes did you use to create your dataset? And how many nodes are you using in your load job?

Thank you Ray.

I doubt it. The limit is for the viewer. Dont know of any variable that will alter that.

Yes. But why are you worried about the view data part. Does your job function properly?

These are primary questions and are discussed before. Try searching for them before asking.

RetCd will have the jobstatus.
Really, please search before asking.

Try to run the delete for say 1000 records from your favourite sql tool. See how much time it takes there.

It should work. Are you giving the correct name of the stage? Make sure there are no leading/trailing spaces.

The error message tells you all. You have reached a limit. What happens when you run the job?

I found the following sql in one of the archives. Enjoy SELECT DS_JOBS.NAME AS JOB_NAME FMT '30L' FROM DS_JOBS, DS_JOBOBJECTS WHERE DS_JOBOBJECTS.OLETYPE = 'CHashedInput' AND DS_JOBOBJECTS.OBJIDNO = DS_JOBS.JOBNO AND EVAL DS_JOBOBJECTS."@RECORD<6>" = 'Your Hashed File Name' GROUP BY JOB_NA...

Then get the record length from the sybase table that you exported data from.

Who ever provided you the file, usually provides the length. If you have to find it out yourself then you will need to do manual work and analyze the records. This is prone to error. Any manual work is error prone. How are you getting this file? Outside of DataStage or within?