DSXchange

Hi ,
I have found the solution for this . Please use the environment variable APT_ORACLE_PRESERVE_BLANKS. This instructs the sqlldr to preserve the blanks for the character or varchar metadata.Its working superb...

One More stuff is that Reject link is not capturing the failed record from the Oracle Enterprise stage ... Any reason if load is enabled will the reject link will not work ?

Hi , Yes i have found teh log in the scartch disk and following are the piece of contents that i am suspecting for the cause odf the problem SQL*Loader: Release 10.2.0.3.0 - Production on Sun Sep 7 06:45:11 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. Control File: ora.1220608.575468....

I am getting quite confused as these scratch disks were used for mostly the sort purpose and join related stuffs. But why does this sqlldr uses the scratch disk for feeding .. As all the records are available in the dataset ....Does this means that all the records in the dataset are first brought in...

Hi , I am extracting from the mainframe file and dumping the data into the target table using the load option . All the fields are non nullable both in the source and the target . But due to the blank spaces in the source PX converts them to null and tries to insert them in the target . The job abor...

Hi i am having the same issue now... Can someone give some clue on this please

The load option uses an sqlldr to load the data .... I am not aware of where i should go and check the sqlldr log files so that i could see about the detailed oracle logged error msgs for the Bad File Number

Hi ,
As said i have added some more length into the string but it still throws truncation warning ie Possible truncation of string[14] to string[12]. The output tab holds the metadata as string[12]( This is the metadata that the target table has)

Hi I am using this function to convert a decimal to the string . I am getting warnings as implicit conversion from source type "string" to result type "string[max=4]": Possible truncation of variable length string. The stuff is its taking string without any length and converting ...

Hi Nigel, Please use your datastage manager for specifying the Header and the last Null row in the mainframe file metadata. Try saving the metadata with these new properties and load them to the CFF stage again. This would show warnings in the director log again when you run .....But px happily exec...

Hi , I am loading 1100000 records into the oracle stage using the write method =load and write mode =append and index mode =Rebuild .The source is a dataset stage. I am recieving the following error when i run the job write() failed: Bad file number But when i change the write method to upsert and w...

Any clues please ...I am not finding these topics using search also ......

Hi I am renaming the columns using the modify stage and i am getting the errors as below
Specification in the modify stage = the error i am recieving is Any clues on this please....

Hi , I am using a mainframe fixed width file as a source and the px is showing warnings as import failed for these two records and the two records are rejected. I would like to ignore the reads of the header and trailer records of the CFF file so that the warnings will not be generated . Kindly help

Hi Any help on this post please. Now i am finding another trouble in reading my mainframe fixed file. The first name contains column and the last line has a footer. I have to omit the first and last lines while i read the mainframe file . Any possiblities for this issue ? kindly help... There are wa...