DSXchange

Before Loading Data to a Target DB2 Table I need to check if "Column A" exists in the Target DB2 Table. If it exists then I need to add one to the Value of a "Column B". For Example in a case like this: Target : Column A Column B A1234 1 A1234 2 A1234 3 Source : Column A A1234 Co...

There are others using the Languae support on their local machine but they have no problem with accessing their jobs. the others did not specify NLS when installation and it still works why ??? How do I check the NLS Settings ??? Login with telnet. If that doesn't work, login on the server itself (m...

How do I check the NLS Settings ???

ray.wurlod wrote:Login with telnet. If that doesn't work, login on the server itself (maybe using Remote Console). Check the NLS settings. Make sure they match the code page set for the Windows environment on your ...

I get the following error message. I tried to login locally to the DS administrator in order to check the NLS setting but yet it gives me the error. Pls help. "Invalid Universe mark characters have been sent from the server, code page 936 may not support these characters, or you may need to ins...

I am unable to view my jobs with the annotations.....and its disabled on the pallete. It was displayed fine the last time i opened it.....how can i resolve it ??

Thanks for all your responses....I guess I have no choice but to handle all the columns for nulls.....I was looking for a simpler solution as I have an enormous number of jobs to alter....thanks again...

I do the following to handle it if trim(Arg1) ="" then @null else trim(Arg1) Are you saying I have no other alternative but to validate every column ??? If you specify " " as the representation of NULL in this field, in the Columns grid, then " " will automatically be r...

Loading data from a fixed with Sequential File to a DB2 Table. Some of the records I load consists of null columns...they are of data type date, timestamp,char,integer,decimal for date and timestamp I use a validation for the null handling.... For the others data types if I dont validate I get warni...

Done...but I thought there would be an easier way to handle it.....but what about the warning ? can i make it not specify it as a warning

chulett wrote:They are two different things. If you want spaces to be NULL in your target, explicitly convert them in your job. ...

How Can I not have a warning incase a null value is being loaded from a fixed with sequential file to a db2 table ? how can I get datastage to treat spaces as null ? AdjBar..Transformer_6: At row 1, link "Output", while processing column "VERSION_NO" Value treated as NULL Attempt...

When Loading From a Fixed Width Sequential File (Space between columns =1 ) how to handle null values....do I have to validate every column ? for eg In the transformer for date column and timestamp column I have a validation such as = If trim(Arg1)="" then @null else iconv(trim(arg1)) Is t...

There are a few columns in the Sequential File that are Null but when loading to the target DB2 table I get a waring ssaying that the column had to be trancated or datastage cannot convert string " " ..... To avoid this I use the function Trim(Column Name). DataStage server doesn't care ab...

For what data types should i use the Trim function ?


I read data from a sequential file and load to a target Db2 table...whether i use a trim function for a timestamp or not I get the desired results...but for a character type if i dont use a trim function i have errors...

thanks guys I have a date field of the YYYY-MM-DD in a sequential file...When I load to the target table I am having an error as follows... how do i fix this LD_RMM_COLL_BAT..TRX_RMM_COLL_BAT_1: At row 113, link "Output", while processing column "COLL_DT" Value treated as NULL At...

expected date format YYYY-MM-DD Target database : DB2 sequential file is of the form YYYY-MM-DD but when i run the job i get the error specified in the earlier message... You start by informing us what the target database is, and what its expected date format is. Then you adjust your value according...