DSXchange

hi guys:
I have the fiollwoing error when I try to read a file in datastage.

read_delimited() - row 1, too many columns in record

I checked the file layout on the Unix box and it exactly matches the column layout of the Datastage job.

Please advise if this could be for a diff reason.

Thanks for the help, it worked.

Hi guys, I have a column 'DOC1' which is 10 bytes CHAR. I have to populate 'A' if this column is blank. I am using the logic If (IsNull(DOC1) Or DOC1=" ") Then DOC1 = A Else DOC1. Somehow, this logic is not catching the blanks on the DOC1, Is there a way to check for the SPACES on this fie...

hi,

The target system need DataStage to provide a file with the columns delimited by tab, what is the equivalent charater for tab?

Thanks

Hi,

Can anyone help me find documentation on DataStage TX.

Thanks

Thanks Mike.!

Hi guys, Can you help me how to save the 'Help Topics' as a readable file. To be more specific, the "Help Topics" on the Help menu which has all the helpful information about DataStage. Can this be saved as a file and can be read anytime we want even though we do not have DataStage on the ...

I unchecked both the options and I get a "Write caching disabled" warnings and the job aborted.

Ok, specific. I have Job1 to create and write records to HashFile1. My properties here are checked the "Create File" and checked the ""Delete file before create" in the Options. In my Job2, I want to add new records to the same file HashFile2. On the General tab, which prope...

How do I append records to the existing hash file.

Hi guys,

How to delete a hash file from a file directory.

guys, I am so sorry to post simple ones like this, I have used this many times before and looks like I am getting too dependent on this site at times, just the moment I see a red on the screen, I come here and post it rather than 't h i n k' a while..

my requirement is to populate 0000's if the filed is null
I tried If IsNull(myfield) Then 0000, the expression is in red, some syntax error?

How to check if a Filed is null, Is there a IsNull function?

i don't want to convert the format, i just want to remove '/''s from the date..