DSXchange

Column is Varchar. In the log following error is displayed:

Xfm,0: Field 'BodyType' from input dataset '0' is NULL. Record sent to reject dataset.

Sorry to say but none of the above solutions are working. The records are still getting rejected. The condition is working fine for other fields. Only 2 fields are creating problem.

Please suggest what to do.

Thanks

Blank means that the value is not present in the input file.The file is tab delimited

Hi All, In the transformer, I have given a condition for a column as: If Trim(NullToEmpty(Col1))='' Then 'Unknown' Else Trim(NullToEmpty(Col1)) But the records having Col1 as blank are getting rejected. I dont want to reject the record, rather replace it with "Unknown" if it is blank. The ...

Thanks one again for your help

I am able to remove all the duplicate records now with your suggestion

Thanks for the quick reply

I'll try this and get back to u if i face any difficulty in implementing

Hi All, If the scenario is to remove all the records having duplicate key,the remove duplicate stage or the sort stage removes all except one.But i want to remove all records. Can it be done in Datastage? Ex: Col1 Col2 Col3 1 001 002 1 001 003 2 001 004 3 002 003 In this example, Col1 and Col2 are t...

One thing I forgot to tell u. I am using a change capture stage also in between. The scenario is that i have to compare tableA and table B and insert new records into table B. I think there is some problem with the change capture only becoz when i tried to insert directly from one table to another t...

Hi All, I am trying to insert data from one table A to another table B. All the columns are just a straight move through a transformer. Table A is having one column which is having values like: Col1 002 004 This Col1 is not getting inserted properly into TableB. In TableB, data inserted is : 0000000...

Hi All,

I have to load data from a file into database.

When there are no records in the file(empty file), then i want to enter 1 hardcoded record into table.

How can i implement this?Could you pls help.


Thanks

Try this

If Trim(DSLink1.okcucl[1,1])='5' Then '020':Trim(DSLink1.okcucl[2,len(DSLink1.okcucl)])
Else If Trim(DSLink1.okcucl[1,2])='65' Then '030':Trim(DSLink1.okcucl[3,len(DSLink1.okcucl)])
Else '001'

You can check the status of the job.

status=`$DSHOME/bin/dsjob -server ${DS_SERVER} -user ${DS_USER} -password ${DS_PWD} -jobinfo ${DS_PROJ} ${DS_JOB} | grep "Job Status" | tr ')' '(' | cut -f2 -d'('`


For running job, the status should be 0.

Can you post the query you are using.

Can it be possible with some data recovery tool available in market?

There is no backup available.Is there any unix command to recover the deleted data.