DSXchange

pxCreateFile: Parallel routine (C++) which creates files dynamically. //Creates and writes on a text file for each record //Pass the FileName with path as first parameter Ex: <Path>: LinkName.InputColumn : '.txt' //Pass the Content of the file as second parameter Ex: LinkName.InputColumn //Px routi...

A parallel (C++) routine which creates files dynamically will be the best way to do this 'in a single run'.

You need to enclose the password in double quotes if it has special characters. If that didn't solve the issue ask your support provider for a fix available for this.

Pre-process to pick the date part from header in file and pass the date as a job parameter.

Set APT_IMPORT_PATTERN_USES_FILESET to True and try. If this didn't work you might have to get a patch from IBM for fixing this issue. Been discussed this before here.

ArndW, I doubt if there is any inbuild function called PadChar() available. Did you mean to say PadString() ? That function is not the best fit to this requirement (Left side / Beginning Padding). Str() function can be used directly without stage variable specification: Str("0", 6 - Len(In...

If you have a job attached inside the routine:

In the above case everything after "/STORES /STORE /" falls into the same level and any field in that level is to be considered as 'repetition element'. "/STORES /STORE /<repetition element level (lowest)>" To get different store information as repetitive level (blocks) of aggreg...

In the input column tab of your XML output stage specify key as any non-nullable column other than your first column ie. STOREID. For example try with STATE as key. Also make sure in the Output -> Transformation Settings tab you have checked Output Mode as 'Aggregate all rows'.

Job monitor application (JobMonApp), which is a Java program that collect audit data / job statistics is not running on the server. See this LINK on how to check this status, if not running, investigate and start JobMonApp on your server.

Sort and partition your records by key field\s so that matching rows are adjacent to each other and on the same node in the transformer. Assign stage variables in below order (Note: Stage variables are processed in order) svPrev = svCurr svCurr = Input.Col1 svOutput (Default Value set to 1)= If svCu...

In that case things are straight forward, FastLoad supports only one target table, so TD enterprise stage initiate/invoke only one fastload per stage.

Depends on the number of TD Enterprise stages you have in your job. So you can count the utility slot by counting the number of stages used per job. Not sure if your job is having some statements written in Before and after sql (open and close command) option available in Enterprise stage to invoke ...

This is a TeraData side issue. The number of fastload / multiload / fastexport (block operations) that you can do concurrently is controlled by the limit set in the "dbscontrol" record - MaxLoadTasks. This limit depends on the database release and the local settings. When this limit is bre...

You have already tested and found out the MQ manager name you used is not right. Reason code 2058 means Error in Queue Manager Name. You will have to find out the right MQ manager name from the MQ admin and try again. How to find out ,whether i have the access priviledges to the particular MQ queue ...