Special Character in DataStage(8.0.1)

[DXNeuerman]

Hi,

We are in process of migrating from 7.5.1A to 8.0.1

We are testing DataStage 8.0.1 Project with current Server jobs (7.5.1A).
We are facing following issue.

Current Production Environment
-------------------------------------------
Platform OS : Windows
DataStage : 7.5.1.A
Job : Server

New DataStage Environment
----------------------------------------------
Platform OS : Windows
DataStage :8.0.1
Job : Server

We are facing following error in 8.0.1.
Issue: Some values (Special Character) in DataStage(8.0.1) are getting converted into NULLS.Description: Job LD_STG_FINANCIAL_TRANSACTION is reading complex file &
loading it into staging table(STG_FINANCIAL_TRANSACTION).

In 7.5.1A jobs runs fine without any errors or warnings. When we are
trying to run same job in 8.0.1 server with same parameters & same data
file.
Job is failing with errors. It is converting some special characters to
NULL.
LD_STG_FINANCIAL_TRANSACTION..StgXLoadProcess: ORA-01400: cannot insert
NULL into ("ISETSST"."STG_FINANCIAL_TRANSACTION"."AFDC_ACCT_NUM")
Screen Shots is attached.
In this case AFDC_ACCT_NUM is getting converted to NULL


Thanks for advice
Parag K

[chulett]

What are your 'special characters'?

[DXNeuerman]

Hi,

Source is Mainframe file.

Special Character looks like small square & they are coming 12 (width of field) times in the same field.

Like I said 7.5.1A no issues. Values are getting inserted into database as they are in file.

I converted that value to ASCII using SEQ function & value we got back is 0 (NULL).

Thanks
Parag K[/img]

[Hemant_Kulkarni]

Did you set the NLS_LANG ?

[parag_pk]

Hi,

I forgot mention. We did not used NLS setting. NLS is disabled.

Thanks
Parag K

[parag_pk]

Hi,

I forgot mention. We did not used NLS setting. NLS is disabled.

Thanks
Parag K