DSXchange

First off, a csv is a "Comma separated values" file. On Unix, you can create files with any name (.csv or .out etc.). But, if you import that into Windows to view it, you cannot immediately open with Excel. You have to use a text editor. I cant get my input with Quotes, its coming from man...

In my experience with this I have learnt that there are many ways a rounding function can be implemented, like Accounting etc. DataStage does it this way. Other tools might use a different algorithm. ArndW is right, there is no bug with this.

Forgot one point, since you are in version 8, you have parameter sets. They can be imported and exported.

Not that I am aware of. If they are Environment variables, then you copy the DSParams file between projects.

I get these errors when I do a "View Data" for my DB2 stage (API) whose NLS is set to "OFF". We did this because we were having "glibc" errors when the NLS is set to Project default. But, the jobs run fine though.

Awesome...I did not notice that so far! By default it is enabled, so never even thought of playing with those. I guess this is what OP wants...

Can you read them using Sequential file stage? Try requesting for a sample and see if you can do so (I am talking about the .tot file, of course). You were already informed on what to do with .dbf file by Craig.

IMHO, the problem that OP posted is not related to Performance Statistics. I am afraid there might be many possibilities on why this behavior is happening. You may have run out of memory by having too many windows open or there is a problem with the Designer client. If nothing works, a re-install of...

The tool will display the behavior that you mentioned if you are dealing with Server jobs. In Parallel, it will produce this elegant "ERROR" kind of a message if you View the data. It should be fine while running a job with empty source/target files.

Write a User-defined SQL query to do the Date masking.

chulett wrote:... and then a TO_DATE() with a matching format mask in your target SQL. ...

...in your target SQL is what Craig meant.

ds_dwh wrote: normally if job is aborted i didn't find any records in target (i mean record count is zero)

That is because you might have had the transaction limit set to '0'.

If you want a DataStage solution, look into UserStatus here. The way you would do it is, you will need to have separate jobs to achieve what you want and these should be part of the sequence. The below steps will be part of a loop that would run based on the time interval that you give (look into 'S...

Sequential_File_38,0: Field "EntityID" has import error and no default value; data: <empty>, at offset: 9 Sequential_File_38,0: Field "FIRST_NAME" delimiter not seen, at offset: 55 These tell me that the Sequential file stage is not properly configured to read the data. Please c...

Row Gen --- XFM --- | File ----------------- Funnel (Sequence) ----Output | Row Gen --- XFM --- *Edited* Metadata for the 3 sources should be the same (1 field). So, read the entire row as one field from your source and do the concatenations the way you wish for the Header/Trailer in the Transforme...