DSXchange

Even ICONV(L1.END_DT,"D-YMD[4,2,2]"):" ":ICONV(L1.END_DT,"MTHS") will not give you what you want. What is the data type of END_DT ? But there is no internal format of a timestamp; so that ICONV() questions are irrelevant. You must construct a timestamp as a string of 19 or more characters, as expect...

What other user? Who issued the chown command? Is there no management control at your site?!!

... and only if you have exclusive access!

If you don't you can leave the repository database in a worse state than when you issued the command. Luckily this can be corrected by another reindexing command, this time with exclusive access to the project.

I've always found it better to use a Sequential File stage, and a custom-crafted CTL file. The CTL file might have been prototyped using the stage, but I just can't see the value in rewriting the same CTL file every time. There are two places throughput will improve; you can tune the CTL file (for e...

Is it reproducible, or did it only happen once? If the latter, the mail client or server might have been off having a smoke or something at the time. If it's reproducible, try simplifying what you are doing as much as possible, then add complexitiy a piece at a time till it breaks, so that you can i...

SIGSEGV is the UNIX signal meaning "segmentation violation", an attempt to access a memory address not owned by the process. Somewhere, something has run out of memory.

Curiously you are not the first to encounter this. Did you search the forum for a match on your error text?

One stage, one task. Fundamental tenet of parallel job design. The Filter stage does not trim. You can trim using either a Modify stage or a Transformer stage. No other stage has a Trim() capability, unless you write your own custom stage. My advice is to use a Modify stage upstream of the Filter st...

Or just use FILLER to make sure every record has the same length.

There's an executable $DSHOME/bin/UVfile that can help to find these "orphaned" hashed files. Use find to capture names, exec UVfile , then grep '(' to select only those with UniVerse file information in their reports. For example: find . -print -exec $DSHOME/bin/UVfile {} \; | grep '('

You could use the stream editor sed for this task.

Easy. You supply a timestamp with microseconds.
There are no inherent data types in server jobs, so you can construct it as a string, and use an appropriate date picture for the TO_DATE function in the INSERT statement.
It's up to you where you get the microseconds from.

ENV is a reserved word - it's the DataStage command for getting and setting environment variables. Use a different name.

You can get this message on any failure to send, for example if the mail client is not running. That is, the problem is not necessarily in DataStage; "they" are trying to be helpful with diagnostic suggestions, too helpful perhaps, since it can be misleading. Of course, it could be that the job para...

Version 1.0 came out in November 1997. Therefore no-one has ten years' experience with the product unless they were working for the vendor at the time. This does not stop recruiters requiring ten years' experience. As to the rest, that would require some research, particularly as to dates. You will ...

Run ACCOUNT.FILE.STATS ALL LOCAL in the project on a regular basis. This updates a hashed file called STAT.FILE in the project. Apart from having gathered file tuning statistics, STAT.FILE contains the device, inode and file name for everything accessible from that account's VOC file with type "F" o...