DSXchange

There's no general formula. You must construct a formula for each file. Let's consider your example of pipe delimited file with 5 columns ( field size expected are Numeric 6,char 10 , date 8 , char 10 and Nchar 3). Numeric 6 may contain from 1 to 6 characters - let's assume it's always six character...

The UV stage itself gives you the option to drop the table prior to re-creating it. Otherwise, yes, the command is
DROP TABLE tablename;

Look beside the UniData stage in the Palette; you will see a drop-down list. This list contains both UniData stage types and the UniVerse stage.

Alternately you can select the UniVerse stage from the Stage Types branch of the Repository.

OK they are separate issues. The problem sqlldr is having is that it can not open the file in the .\pipe folder. Verify that the executing user (the sqlldr identity) has sufficient permission to the pipe folder in the project folder and/or write permission to the project folder itself (so that it ca...

Make sure in advance (in the job sequence) that there is at least one file that matches the pattern. For example, use an Execute Command activity to ls the directory with the file pattern, and test its exit status or output using the Trigger expression. You could, as an alternative, create a message...

How did you create the UV table? If you created it with CREATE TABLE, then the command to create the index is CREATE INDEX (everything in SQL). If you created it as a regular hashed file, then the command to create the index is CREATE.INDEX after which a BUILD.INDEX will be required if the data have...

The operating system will report the size of the text file when you do a DIR command. Calculating - or, more accurately, estimating - in advance is a bit more tricky. For example, numbers are converted into strings of characters. Do you have in mind a fixed-width format (in which case the file size ...

That's not the sqlldr log file. It's probably a separate issue, or the message here and the message in the sqlldr log file may relate to the two ends of the same named pipe. Please post the sqlldr log file error message as requested, so that your diagnosis can be more accurate.

However you can not use this server function in a parallel job. The place to use it is either in an after-job subroutine or in a routine invoked from a Routine activity executed after the job in a job sequence. For example an after-job subroutine might have the following code (the file pathname is g...

Were you perchance using Entire partitioning? That will definitely cause duplicates.

Search the forum for techniques. Oracle client software must be installed and configured - for example you will need Oracle environment variables such as ORACLE_HOME and possibly ORACLE_SID in your dsenv file. You will also need tnsnames.ora properly set up. Consult your Oracle DBA for advice - this...

This script works fine in Toad but no row is updated. Would you like to clarify that statement? How can it "work fine" if an UPDATE statement updates no rows? Answer: if there are no rows that match the WHERE condition. In that case, DataStage would achieve the same "result". What is the Generator ...

The $DSHOME/bin/UVfile command will report whether a particular file or directory is a hashed file. The existence of DATA.30, OVER.30, .Type30 and nothing else in a directory signals that that directory is a dynamic hashed file. You can encapsulate this in a script that traverses your file system lo...

battaliou was having a laugh - look at the verbs in his final clause

The Fix() function comes closer than the Int() function, but it remains true that there is no Trunc() function in DataStage BASIC.

Still waiting for the results of pradkumar's diagnostic investigations before chasing any red herrings.