DSXchange

My scenario is like this: For each input record, the process should examine to see if there are any prior records for that member. If there is an existing record then that record END_DT should be update with current record IC_DT. For example, 3 source records for a member could be Rec1 --> IC_DT=1/1...

Thanks that worked,Now i do not see the warnings.

But I was wondering how this parameter operates.Does it have any effect on the other sequential files(for example if i have a sequential file and also a sequential file to accept rejects).

Thanks

throbinson I am not able to find the variable APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL in environment variables.In which section can i find this variable.

Thanks

That is the reason I am putting a transformer in between and handling nulls. But i wanted to know if there was any effective method to handle this.

Thanks

Ray, If it is a reject link from a Oracle Eneterprise stage ,it is not allowing null field value for individual column in the sequential file.It allows a Null Field value only in the Format tab of the sequential file.So I gave Null field value as " " in the format tab,but since some of the...

Yes,Ray agree with you that it should have same format and size of characters or numbers to represent a null. My question is as a Sequential file (which stores rejects from a Oracle Enterprise stage) does not allow Null field value to be edited,I am placing a transformer in between a Oracle Enterpri...

Can some one throw some light on this matter.

Thanks

Do avoid this warning,I have a Reject link from the Oracle Enterprise stage which is Input into a transformer and than from the transformer I have a sequential file where the rejects are landed (where it allows me to manipulate the Null by Field value). Is there a better way to handle Null fields in...

When I set it to '' it gives the below error

When checking operator: When validating export schema: At field "XXX": "null_field" length (0) must match field's fixed width (8).

Thanks

Can some one,throw some light on this issue.

Thanks.

But,when i define it at field defaults,it would not match all my columns(i.e some of them are Date column,some are varchar and some are decimals).

How can i define a single Null field value for all of them.

Thanks

How,was this resolved.

Thanks

Hi, I have a job which loads data from a sequential file into a oracle table. In the Oracle Enterprise stage,I am using the write method as upsert. I have the option Output Reject records set to True. I am directing the rejects into a sequential file. I have set the Null Field value as \123 in the f...

That worked.

Arnd, Am I right,that we do not have to specify the column names in insert into statement if you are entering all column values in the same order i.e Insert into xxx values ............
I think that would help.
I will try this.

Thanks