Search found 40 matches

by kiranh_1214
Mon Aug 05, 2013 8:07 pm
Forum: General
Topic: failed to authenticate current user against the selectedtier
Replies: 4
Views: 3250

failed to authenticate current user against the selectedtier

Hi All, I have IIS Server running on Linux ( Linux installed on VMware) anf all my services serives are up and running on linux. I have installed 8.7 client on OS Win7. I established connection from linux to win07. When i trying to connect Designer i will get the below error. failed to authenticate ...
by kiranh_1214
Wed Sep 28, 2011 4:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: NLS - Unable to see Chinese characters
Replies: 3
Views: 1859

Source data as 上海嘉华中心支行--*G* 安装保宝系统
by kiranh_1214
Wed Sep 28, 2011 4:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: NLS - Unable to see Chinese characters
Replies: 3
Views: 1859

NLS - Unable to see Chinese characters

I will be reading the data from an Oracle DB and loading into DB2 table From the source one of column data receiving as chinese character and try to load the data into DB2 table , but data has been loaded with some ???????????? Here is the complete details Source DB: Oracle Column : TITLE data type ...
by kiranh_1214
Tue Jul 19, 2011 6:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Build Op stage - data is not loading into target
Replies: 3
Views: 1591

Hi All

I made changes to my build op code
it's working now....
Thanks
by kiranh_1214
Tue Jul 19, 2011 5:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Build Op stage - data is not loading into target
Replies: 3
Views: 1591

Hi Ray

I place peek stage before build op and after build op stage
I am able see records in peek stage before build op

data is not passing from output link of build op
by kiranh_1214
Tue Jul 19, 2011 4:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Build Op stage - data is not loading into target
Replies: 3
Views: 1591

Build Op stage - data is not loading into target

Hi, I am trying to create a new build parallel stage for adding two numbers. I have given input port as 'indata' and output port as 'outdata'. The input table definition is two columns 'Col1' and 'Col2' and output table definition is one column 'Col3'. In Per_Record tab, I have given the code as out...
by kiranh_1214
Thu May 06, 2010 7:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequence numbers are generating in native
Replies: 5
Views: 1815

The dattype of svCntr is BigInt . I am passing initial values as 0.
and target DB2 table column as BigInt .
by kiranh_1214
Thu May 06, 2010 6:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequence numbers are generating in native
Replies: 5
Views: 1815

Every time i am passing MAX(Val) from the target table.
by kiranh_1214
Thu May 06, 2010 5:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequence numbers are generating in native
Replies: 5
Views: 1815

Sequence numbers are generating in native

Hi All I have job in Production which will compare the previous day and current day files in CDC stage then generating sequence numbers in transfer stage (running in sequence mode ) for every new record. Transformer logic. if lnklkptotfp.change_code =1 then @NUMPARTITIONS+svCntr else svCntr Now the ...
by kiranh_1214
Fri Mar 12, 2010 3:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How do I get lookups to find updated records immediately?
Replies: 2
Views: 1198

How do I get lookups to find updated records immediately?

Hi All, I have a Scenario like, As soon as the records enter into my target table the data should reflect in lookup table. Target table: DB2 Lookup table: DB2 ( target table) Scenario: ==> A Token already exiting in table with status available (103) SER_SEC_TOKN_NUM IP_ID_CUST IP_ID_USER SEC_TOKN_AC...