DSXchange

Do you happen to know what's in the patch? In particular is it a different version of the ODBC driver?

Surely ALL reasons for failure are unexpected. Do try to create more meaningful subjects!

What's in the file?

handed to ExecSH as an after-job subroutine.

Have you tried delimiters such as ctrl-Y (025) or ctrl-A (001) ? How about something above 128, say 170 (which I chose at random) ? Or 255 or 254 ?

Don't confuse the time it takes to return the first row of results (in TOAD) with the time it takes to complete.

Look in RT_BP28/JOB.1521029963.DT.1443855705.TRANS1 at or around line number 91 to see what you can see there. This file will exist on the DataStage server machine.

Each causes additional entries to be logged. APT_RECORD_COUNT causes each player process to log an entry showing the number of records it processed. It does this as part of its shutdown processing. OSH_PRINT_SCHEMAS causes each player process to log an entry showing the actual record schema it used....

Is johm73 the same poster as skumar (the original poster)?

This could also be built as a server job, containing just a Transformer stage and a Hashed File stage, that generates exactly one row containing the sequence name and new value.

This is the example used in IBM's training class except that you have missed the most important part, namely the fact that SH is not the command they issue, but rather one that expects to get name=value pairs on its command line. $JobName and $JobStatus are "activity variables" whose purpose should ...

There would be an issue with the indexes; you would need to DS.REINDEX ALL in both projects after all the mv commands. Also, DataStage would still have recorded in its "system tables" the old names at their old locations, which would need to be corrected by updating UV.ACCOUNT and by using VERIFY.SQ...

It's one at a time.

You could create a shell script that invoked orchdbutil over and over, but there's nothing "out of the box".

Not true. Multi-instance jobs run as and when you request. That said, you don't need multi-instance to run the same job over and over but only one instance at any one time. Why do you have this strange requirement to load only 10MB at a time? Is this your design, or an imposed requirement? If the la...

WHERE are you proposing to use this function? If you need the row count inside a Transformer stage it's already exposed through system variables. If you don't need it until the job has processed all rows, then you can use DSGetJobInfo() - or the macros that you discovered - in an after-job subroutin...

In record 0 (the first line in the source file/data set) you don't have enough metadata to describe the entire record. Is the field delimiter correctly set? Is the record delimiter correctly set? Do you require a final delimiter?