DSXchange

DIRectory listing of the files
Flatten the list into a single comma delimited record of filenames
Read the file with the single record of filenames with a User Variable stage
Pass the uvParameter to the Start Loop (List Loop, Comma Delimited)

After setting up a new Development project on a separate server we started to encounter a the ORA-03127: no new operations allowed until the active operation ends fatal error. The DS Admin pointed me in the direction of the DBA, the DBA had never heard of the error and didn't have any information ab...

Thank you for the replies. Currently these are the lookup file counts by date in the Resource Disk directory 3/19 - 253 3/18 - 251 3/17 - 251 On 3/16 the DataStage server was rebooted after Windows Updates were applied. The majority of the files are very small but there are a few larger ones as well...

In the Resource Disk directory there are lookuptable datasets that are several days old. I would have thought that these would get cleaned up as processes finish but apparently not or not always. Can someone advise why some of these datasets would be left in this directory for several days and what ...

We've tried that several times. For a workaround we use a dsx for those jobs that fail in the Package. The export of the single job to a dsx took several minutes, like more than 5. Perhaps there is a timeout limit with a package element that causes the failure? Just a thought.

Thanks for the reply.

The deployment fails in all environments for the same jobs but I'll ask the Admin about the script and re-indexing. Also wouldn't the dsx import also fail if there was a lock on the job?

No errors pop up when accessing to logs.

When deploying a package with multiple jobs one of the jobs fails every time. To get around this the job was moved in a dsx. The message from the compile listing is: Failed: Unexpected error importing design. See the log in the Web Console for more details. What Web Console has the log? Nothing was ...

After creating a package of just executables in our DEV project (all parallel jobs) the package was successfully deployed to our TEST project using ISM. To move to MODEL, which is on a different server, we are first required to send the package to the LAN where the DS Admin attempted to deploy the p...

Our shop is attempting to implement a source control system for our DataStage elements using Subversion. We have added the eclipse plug-in to ISM and can access the DS repository, Send to SC workspace, and add jobs to the SVN repository. When a job has been added to SVN the job has a suffix like 0 1...

Fair enough. Thanks for the information.

Column Meta Data

SQL type: Decimal
Length: 3
Scale: 0
Nullable: No
Description: <none> Seachable? N
Properties: Field level, Quote = none

The example above was copied from the .txt file in word pad.

When writing data to decimal fields with a parallel job the value is preceded by a space and ends with a '.'.

The second field is SQL Type: Decimal, Length: 3, Scale: 0
"B", 000.,"000"

What would cause this behavior?

NLS was indirectly to blame. There is a data edit routine that was modified because of NLS being enabled. One of the functions of the routine was to reduce fields consisting of only multiple spaces to a single space. This was omitted in the 9.1 version so since ' ' is not the same as ' ' the CDC cal...

NLS is disabled in 7.5.2 but not in 9.1. Could this be affecting what is passed to the function?

Setting up some jobs to capture the values passed to the function.