DSXchange

pravin1581 wrote: INROWNUM is not giving the total row count but incremental count.

Stick in an agregator at the end and group on a static field (if not present create one) and specify LAST for the INROWNUM column to get the last record which will be the rowcount.

Read it as varchar, trim the field and then apply StringToDate() to it with the format "%mm/%dd/%yyyy".

RCP is a good option that px jobs have but thats just for propogating the records. For any explicit transformations, the columns need to be defined.
And Yes, your requirement can be met in px jobs as long as you understand about the limitations of rcp.

You can do it at the database level or do it in seperate stages and collect them. It depends upon how much temp space you have, how much loaded the database will be when your run the query. Will your DBA allow that ??? etc. etc. etc.

First of all , what kind of routine is it? Is it a C routine or a Basic routine?
You mentioned Job Control so I am guessing its a Basic routine as for a C routine you must be executing it with DSExecute() at the OS level. Fill in some blanks for us, will ya.

I cant think of a graceful way of doing this within a single job. Its better to keep it in a sequence job. You can have a shell script that is fired as a stand alone that runs the dsrecords orch command and depending upon the output, decides whether to run the job or not. Otherwise stick to a sequen...

I believe you are right. You can concatenate an empty string.

You can also load the 5 links into 5 different flat files and in an after job subroutine, cat them all together.

The hashes (#) show up in SAP right, so I guess you need a SAP expert to tell you what needs to be done. Or trim the fields before loading.

As Ray advised before, send in a link with only inserts, and a reject link coming out of it going to another stage with updates.

Great. We have a confirmation. Thanks seanc217.

I think your better off posing that question to support. Not very many people have 8.0 as of yet. On top of that, using Multi Client Manager.

Thispost seems to have a poster who is claiming the same.

Ok fine. Find out where your compiler lives. Get that path and specify that for the APT_LINKER and APT_COMPILER.

As I indicated before, the metadata needs to be identical.