DSXchange

Thanks Priyadarshi .. Will do some searching further on it.

Any reply,hint,documentation pointer, please !!

Hi, I went through Datastage documentation on NLS use & setting , however couldn't get simple fact that how NLS setting helps in processing data which is in different character codes I read , - NLS mode works by using two types of character set: 1. The NLS internal character set 2. External char...

Thanks for quick reply.

( I will try to close the topic ( if allowed) if have no further doubts in couple of days).

np... I had reply from within the team and as per reply, read ( simple fetch or through SQLs) always completed prior to load. Besides while doing fastload (bulk --> load in append mode) orchstrate work table is created and loaded with data , then appended to target table. So there shouldn't be any i...

Can any one reply to above question?

Hi , I need to confirmation about a case where i am fetching data from Teradata table and loading data into same table through TPT stage in same job. As of now , job is loading data without any misappropriation. What i understand TPT->Bulk->Load is fastLoad method. So it should create empty work tab...

Hi, Below is layout we were provided. I need some details on it. May be helpful for everyone here. RecordDef('RecordLevel1', Ref=RecordLevel1 ); Field('PathRidCode','X(1)', Ref=PathRidCode ); Field('PathRidCode','X(1)', Ref=PathRidCode ); Field('TicketNo','X(13)', Ref=TicketNo ); Field('TicketNoFill...

The function you are looking for is SEQ(), which will return the numeric representation of the input single character, the function that returns a character given a numeric representation is CHAR(). Both can be looked up in the documentation and exist in both Server and Parallel versions. Thanks fo...

Hi, We need to get the ASCII values of incoming data to check whether they represent special chareacters. There seems to be function 'ASCII' and has couple of help pages in DataStage on that; but in tramsformer we are not able to use it. Transformer shows error like ' ASCII not defined.' So is it li...

Hi, I am novice to CFF satge and EBCDIC files.I m trying to read EBCDIC file through CFF stage. I set properties , Record Type= Fixed Char Set=EBCDIC Data Format = Binary Byte Order = Native Indian & then imported Pl/I definition. While viewing source data i am getting error, "error executi...

Hi, I am new to EBCDIC file format. I am reading EBCDIC file through Seq. file stage ( not CFF). Below properties are set : I referred exisitng simple jobs from our repository. character set : EBCDIC byte order : big-endian data format : binary Recod Type : implicit , delimiter : none. I have below ...

Integers metadata properties Default=0 and Field Width=8 solved the problem.

Very simple but somehow i could'nt read it earlier.

Marking topic as Resolved.

Hi , I am reading fixed-width file having integers. I have 2 requirements where, i> I need to read null value in Integer field ii> Should be able to read small integers in 8 digit format e.g. should be able to read '10' also in 8 width format. I have tried all permutation & combinations except t...

Not really an answer or even particularly true. :? What is the difference between the two runs, anything? Or did you literally run the job twice with no changes in the job or environment and get these two results? Your results are not identical as the problem has been reported by two different obje...