DSXchange

A table in AS400 has a column named CREATED with datatype Date and it is NOT NULLABLE. I am using the DbVisualizer to view the records. In that most of the records in the CREATED column shows as (null). But I don't understand why, since the CREATED column is NOT NULLABLE. I am using the DRS stage to...

hi i think it is russian language(cyrillic) i also tried changing nls charset in job properties to russian according to this link below, but its not working. http://www.w3.org/International/O-charset-lang.html now im sure it is russian lang, in my oracle NLS_CHARACTERSET is AL32UTF8 if i try UTF8 ch...

Hi ArndW & chulett yes there are around 120 columns in the oracle load i have narrowed down to 6 columns which cause this error those columns are varchar2(50) only example : LAST_NAME (Column name) (varchar2(50)) : " Объяснение проведенных работ проведенных работa_2 " Length : 49 While...

thanks for ur reply craig,

i set the APT_DISABLE_COMBINATIONAL parameter to True , it shows that the error is in ORACLE stage only while loading ,same error occurs

<b>U_TRUNCATED_CHAR_FOUND encountered </b>

thanks in advance,

thanks for ur reply craig, i hav searched and tried with the previous posts they told to set false to APT_disable_combinational_operator parameter and run the job and then rebuild the indexes present in the target table, still the same above error persists i have done many searches on this error ,bu...

hi while loading a table ( DS->CPY->ORA) i encounter this fatal error i had set Default Map set for Stages as UTF-8 in NLS tab present in Job properties APT_CombinedOperatorController,0: U_TRUNCATED_CHAR_FOUND encountered. U_TRUNCATED_CHAR_FOUND encountered Please help me on this .. Thanks in advance

Check whether you have handled null.

If your source column is NOT NULL and the Target table is NULL then you might face this type of error.

You will need need 3 jobs 1. Job1 which has lookup stage and captures the rejected data in Dataset1 and matched records in Dataset2 2. Job2 3. Job3 , In this job take Dataset2 and connected with a Basic_transformer and use this(If @INROWNUM >0 Then UtilityAbortToLog('aborted') Else 1) in the stageVa...

Sorry Ray

I did not understand.

Thanks Ray This is what I did to get the value of ORA_PWD from the Environment I assigned a value for variable called PWD=aaa and then used the below command in the .profile PWD=aaa; export $PWD (dont know whether this is necessary or not) dsadmin -envset ORA_PWD -value $PWD ProjectName in the Admin...

Hi All I have created a user defined Environment Variable called ORA_PWD and set the default value as $ENV In the .profile I gave ORA_PWD=aaa; export ORA_PWD if I put echo $ORA_PWD, I am able to see the value for ORA_PWD as 'aaa' I used ORA_PWD = $ENV as job parameter in my job which contains ORACLE...

Thanks Craig I will put this topic as Resolved and explain the situation I have faced 1. I took a export of the project from Datastage Manager 2. Saved the .dsx in the DataStage home directory and imported the dsx from the command line 3. I found that there were no job design available in the Design...

Well, as time passes
I think the import command imports only the job executable not the job design.
I wonder a Datastage projects without a job design would be useful or not.

Please correct me If any

Hi all, I took a export of the project from the DataStage Manager choosing the options a) Job Design b)Executables including program sources 1. While I tried to import the dsx with the DataStage Manager, all the jobs were imported successfully and all Job design were available and I was able to run ...

I haven't been able to get a solution for this. However I changed the name of column for the source similar to that of columns from reference. That is Dataset1:(Acts as source) ---------- record ( RECORD_CODE: string[max=2]; CODE_SEGMENT: string[max=1]; LIB_SEGMENT: nullable string[max=30]; CODE_SUR...