DSXchange

You have not identified and defined the repetition element properly.

dav_mcnair wrote: Any ideas?

You can use Field function this way

Field({InputString},{Delimiter},{Position},[{NumberOfFields}])

Make a check T_LKP_JOB_STATUS job which will read all the 3 columns - JOB_RUN_DT, JOB_STATUS and JOB_DESC in the status table. Pass this to a transformer stage in this job and if 'all 3 columns are successful' , as noted earlier in this thread set your USERSTATUS (Search the forums for USERSTATUS) t...

ArndW - Missed the -2 part.
Finding is right, invoking the job with a different invocation id should resolve the issue.

Controller problem: Error calling DSRunJob - Is because - edw_common_ClearStopQMsg - this job is not in a runable state. You have to do a re-set and run. Check if your compiled base job was called previously and currently not in runnable state or a perticular instance was aborted and you are trying ...

1. A "Right truncation of string data" error means that a value in a field is too long for the field. These error messages are thrown for specific records which are coming in the above fashion by teradata CLI whilst it rejects those records. This should have been recorded as a warning mess...

Database table ! Names of the tables are ERR_cookie_1 and ERR_cookie_2. Cookie can be found on the terasync table. In that table, you may use start time and end time (integer) fields in order to find the last ones inserted and you cannot modify these error table names. This should lead you to formul...

Your development project and test project are in the same server and sharing the same MQ connection. Development environment jobs are still running with already established connections. If you want to test this check the MQ Manager for active connections on the queue from MQ side. When i execute my ...

You might have to install a patch for resolving this. Pls. refer this LINK for details.

Old Post... For Records

If the same job is working in one environment and not in another environmebt, then it got to do with environmental settings. First to suspect is the APT_CONFIG_FILE. Check all the servers specified in the APT_CONFIG file for connectivity success.

xmli.so related error message may be related to your xml plugin installation/configuration. Check the permissions in the DSEngine/lib directory also.

Are you looking for a specific kind of code? Because this requirement is posted for the 3rd time by same poster.

Answerd here: viewtopic.php?t=113535 and here : viewtopic.php?p=254377

Set the pad character to space and then try. One of your fields might be coming padded with null. If still it is not working, try converting both the fields into numbers and then compare.

To insert 2 million records you might have used one of the database stages which call one of the Teradata Utilities like MultiLoad, FastLoad... DataStage writes all the records into a named pipe or file and loading to Teradata table happens using one of the utility mentioned above. Records rejected ...

Check your syntax:

ziedkhouja wrote: I try the syntax string [ [ start, ] length ]