DSXchange

Try importing in the same project, when it says that the job already exists, want to continue, hit yes or ok. See what happens.

Actually when is the log table to be populated and how? Create a delimited text file that contains all the information you need for your log table. Have a job run at the end of your process that populates this table. Coming to Error table, this table is used instead of reject file. Is this so? Plea...

I say perform a benchmark. See how much it can handle. Nothing is better than analyzing results yourself.

There is a way, load it into a temp database table and go wild with the sql
Jokes apart, that is a very good enhancement piece. ODBC can connect to flat files but thats limited to windows. For unix, they want $$$. Someone should come up with a cool utility that can run sql queries on a flat file.

I am so late. It got resolved . My share of saying; You can also do this. Ans = "" cmd="SELECT JOBNO FROM DS_JOBS WHERE NAME NOT LIKE '\\%' SUPPRESS COLUMN HEADING COUNT.SUP;" Call DSExecute("UV", cmd, JobNoList, ReturnCode) If ReturnCode<0 Then Ans=@NULL End El...

What is your source system? If it is a database then you can do the subtraction in the sql query itself. Most databases have built in timestamp manipulation functions.

I say remove duplicates in the select itself.

ray.wurlod wrote:Alas, there's no ODBC stage in mainframe jobs.

Its a px job. The mainframe tables are visible to his px job.

PeterPol wrote:APT_COMPILER: cxx
APT_LINKER: cxx

Is that the path for your compiler and linker. I dont know about you but that doesnt look correct to me.

How many input columns do you have and how many output? That makes a difference.
Also, if its just one column, do Cat file file file > finalFile.txt

As per your error message, try doing a cat of the file at the unix level. What do you see?

Search here for keywords like Unlock job.

I thought that limit was only for unix servers.

Well then that should tell you something, that it does'nt accept characters.

Try fixing them then and see if it resolves the problem. Give the correct path for APT_COMPILER and APT_LINKER and correct options for APT_COMPILEOPT and APT_LINKOPT.

Welcome Aboard
It is doing what you asked it to do. Converting it to Decimal(5,1). What is the datatype of this particular column, as defined in your output link. What is your output , is it a flat file or database?