DSXchange

..here are the limitations on the int fields( except SMALLINT ).. BIGINT : 64 bit - 8 byte . This is an 8 byte integer with a precision of 19 digits. The range being -9223372036854775808 to + 9223372036854775808 INTEGER: 32 bit - 4 byte. This is a 4 byte integer with a precision of 10 digits. The Ra...

Using the followiing example: OutPutDate = DateFromDaysSince(-90, Link.InputDate).. but there needs to be more rigor wrapped around for the Month of Feb, as well as Leap Year calculation... ..another sure shot method is ..if u can extract this data from a DB, using a User Defined Query ( like using ...

Hi, I'm trying to use the modify stage for reformatting one col. I gave following derivation as the specification in the modify stage: CRSLT_LEAD_REC=left(LnkForLkup1.CRSLT_LEAD_REC,4):"-":right(LnkForLkup1.CRSLT_LEAD_REC,2) it is compiling successfully, but during run it's giving followi...

..try using a copy operator prior to the seq file and clear the Partitioning on the Copy Op...this shld work..

thanks

Hi, In the modify stage when i am handling the null value for a date column, for the following expression MKTPRC_DATE=NullToValue(MKTPRC_DATE,'2222-12-12') i was getting the following error-- main_program: Errpr passing modify adapter: Error in binding : Unknown conversion : NullToValue Expected des...

ray.wurlod wrote:You don't need administrator privileges, but you do need to use the Administrator client. When on the Projects tab there is an NLS button.

ray,

I checked this and NLS is not enabled. The default Char Set is UNICODE unless i am mistaken.

thanks

Do you have NLS enabled and, if so, what client character map are you using? It seems odd that "Hello" is being converted accurately but "!" is not. Are you sure it's really "!"? (Check with a hex editor both in the EBCDIC source and the ASCII target.) Could be a stran...

hello all, I am reading a Mainframe file thru Sequential file stage . The Format of the sequential file is specified as .. Charcater Set is EBCIDIC and the data format is Binary. I am reading a Char(40) or PIC X(40) field and strangely all the exclamation '!' characters on the Mainframe are being tr...

people, I have a job that uses DB2 enterprise to pull data from a table and then i have a transformer that does some manipulation of this data. When i run the JOb the Job completes successfully but i get the follwoing warnings: Warning: The following libraries failed to load "V0S145_testXfmChec...

pnchowdary wrote:Hi srikanth,

Even in PX jobs, the sequential file stage has an item under options ( First Line is Column Names ). It can be either set to TRUE or FALSE. In your case, you would set it to TRUE.

I do not see any such option in PX Sequential stage...

hi all,

may seem like a Duh! Question..but i was wondering..

How we can specify in a Sequential file Stage that the First Line in the input file is Column Names...i know in Server Job....How about in PX?


thanks,
srikanth.

people,

When using a sequential stage with the read method as 'File Pattern', i cannot use "Number of Readers Per Node" option as they are mutually exclusive..

can someone explain why they are mutually exculusive ??

thanks

hi eric,

I am not trying to use any special env varaibles.. the API was previously working fine..but now it does not seem to work.. as ray had said do u think its a problem with the Virtual Memory allocation..

..all inputs are welcome..

thanks

ray, the following is how the node ccsidbu1 is defined as node "ccsidbu1" { fastname "ccsidbu1" pools "DB2" resource DB2 "1" {pools "DB2"} resource disk "/opt/etl/staging/mad/resource/dataset/dataset1" {pools "DB2"} resource scrat...

thanks for ur inputs .
but can you be more specific.. by permissions ' what permissions are we talking about and what about the db2 level partition'

thanks