DSXchange

Hi

I am working on Infosphere 8.1 at Windows Platform .
I have setup APT_DB2_INSTANCE Environment variable but still i am unable to connect to DB2 .

I couldn't find detailed step to configure DB2 at Windows platform .
Please help to resolve the issue .


Regards,
Shalini

Hi , I am trying to install Infosphere 8.5 in Windows Enterprise 32 bit system . Installtion it failed with following error in between : com.ibm.is.install.exception.ActionException: CDIIN5123E: ExecuteScriptAction failed: the process returned error code 2,002: JVMJ9VM019E Fatal error: Unable to fin...

Hi , I have installed Infosphere Server 8.5 in 32 bit Windows system . After installation , while trying to open any of Infosphere components , sytem is not launching any of the applications .In Event viewer , is ee some messages as : The description for Event ID 0 from source IBM Java cannot be fou...

Hi , I have a requirement to load multiple target tables using a single job . I am using Loop in sequence for this and have created a file list to pass necessary database tablename values to it . (FileList as follow: SRCNAME,TGT_TABLE_NAME,TGT_CONN,TGT_USERNAME) I am facing issue with passing passwo...

Hi Ray,

Examples mentioned in pdf are for fixed width file only .
If we comma separated (delimiter) file with 10 columns , and we require data for only few columns ,how to specify them .As delinmited file will not have start and end position of data .

Please help in this .

Hi, I haveseven fields in source and i want to use only last five fields . I saw a roperty coltoignore in datsatge help in which we can define numer of character to ignore while defining the schema . As my file is comma separated file and do not have fixed width , i want to pad # if field length is ...

I am also facing the same issue .
Did you get any solution to this problem ?

Hi, I have few questions about usage of Partial schemas: 1.)If we define few columns in sequential file column metadata tab and want to use partial schema file for other set of columns ,can we achieve this using partial schema file concept ? As my source file is comma delimited and have 3 set of def...

Hi ,
I have a requirment to implement oracle function ASCIISTR using datastage . I can't find this function in parallel job .

Please help me in understanding how can w e implement ASCIISTR function equivalent in Datastage 7.5 Parallel jobs .

Hi , I am getting input data as follow in a sequential file: a: test us,osjkjkj b: ab c: defhj a: tes1t usa,osjkjkj b: cd a: tt usa,osjkjkj b: ef c: ghij d: defhj Required output format is : a|b|c|d test us,osjkjkj|ab|defhj|NULL tes1t usa,osjkjkj|cd|NULL|NULL tt usa,osjkjkj| ef|ghij| defhj Note: a,b...

Hi I have a requirement where three sequences can run in parallel and 4th sequencer should run only after all three sequencers ran successfully. I am using below design for this: Job1--/--/>Sequence Activity(All)--->Job 4 / / Job2/ / / Job3/ Is it mandatory to put OK-Conditional trigger for all jobs...

Hi,
In StringTodate function you should specify incoming date format not desired date format i.e StringToDate(datefield,"%dd%mm%yyyy") if you source adte is in ddmmyyyy format .

Easiest would be a constraint expression based on IsValid() function. ... Hi Ray, I am using reject file associated with Oracle Enterprise Stage and don't want to use two reject files one with transformer and other with Oracle Enterprise stage also . Is this acceptable behaviour of DataStage that i...

Hi , I am getting source adta as pipe delimiter format . It has a date field in dd/mm/yyyy format . So in seq file i defined it as varchar and in transformer i am applying StringToDate function to convert this into date field and loading to Oracle Enterprise Stage . The issue is if in particular dat...

It tends to work properly when Array Size is set to 1. ... Hi Ray, I am using Oracle Enterprise satge with Upsert mode . Not sure what will be impact of setting array size as 1 ,still i changed it but ,its still not working , I was under impression taht For any of the oracle errors job should rejec...