Search found 95 matches

by rajan.n
Wed Jul 16, 2008 2:18 pm
Forum: IBM QualityStage
Topic: Fatal Error: Field not found: keyChange
Replies: 8
Views: 4243

Yes I did provision all...!! I wanted to do a basic comparision. using the original columns.( Not using any of standerdize generated columns). But still i see the same error.. one more question : when we give the test parameters in the match specification do i need to give the DB name DSN name there...
by rajan.n
Wed Jul 16, 2008 1:05 pm
Forum: IBM QualityStage
Topic: Fatal Error: Field not found: keyChange
Replies: 8
Views: 4243

Hi Emeri, I have tried in that way too. I have included 5 Match commands say : src_name - ref_name src_addr - ref_addr src_city - ref_city src_stage - ref_state src_zip - ref_zip , and for the same coloums i have included the Blocking columns. still the error exists..... Can you please let me know t...
by rajan.n
Wed Jul 16, 2008 12:37 pm
Forum: IBM QualityStage
Topic: Fatal Error: Field not found: keyChange
Replies: 8
Views: 4243

Fatal Error: Field not found: keyChange

Hi While using the Reference Match stage in my job , The job aborts throwing the error "main_program: Fatal Error: Field not found: keyChange" The prev message of this fatal one is Reference_Match_12: Creating sub-operator: <QSmatStats -workDir ./RT_QS37/V0S12 -f Reference_Match_12.txt> Cr...
by rajan.n
Tue Jul 15, 2008 4:13 pm
Forum: IBM QualityStage
Topic: Handling Name with spl characters
Replies: 7
Views: 2911

Thanks Ray,

Can you please clear me how this C-Mask and X-Mask will help me , with what stages and what all the stages I need to use here ?

Thanks again.

Rajan
by rajan.n
Tue Jul 15, 2008 2:01 pm
Forum: IBM QualityStage
Topic: Handling Name with spl characters
Replies: 7
Views: 2911

Ray , I learnt that i need to use the standardise stage and with the multiple outputs which i get , i need to select the one or two coloums which are qualifying my requirement. Please correct me if am wrong. regarding the mask C , or X - when am using the standardise stage where can i perform this o...
by rajan.n
Mon Jul 14, 2008 6:56 pm
Forum: IBM QualityStage
Topic: Handling Name with spl characters
Replies: 7
Views: 2911

Hi Ray , Thanx for the reply. I see that i need to override by using the following code "OVERRIDE_D Lookup_Value @Table_Name Return_Code [ CLASS | VALUE ] " can you please let me know indetail please (steps) , and where to create the table and do i have to use the investigate stage ? Which...
by rajan.n
Mon Jul 14, 2008 1:17 pm
Forum: IBM QualityStage
Topic: Handling Name with spl characters
Replies: 7
Views: 2911

Handling Name with spl characters

Hi All, ( I am very new to QualityStage ) Here I got a requirement : The names are included with Mr. or Dr. and some of the names have the ending part as (Sp?) ( I dont know what this means but this need to be get removed ) For example : Ray Biactin (sp?) : Ray (sp?) : Mr. Ray Biactin I need the fir...
by rajan.n
Thu Mar 27, 2008 3:03 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Need a logic to pic a date attached file
Replies: 3
Views: 1106

Read all the files in a folder and pass it as parameter to the job, using a script. Or use execute command activity to pass as parameter and LoopActivity to loop through each Filename. ... thanks for the quick reply , Can you give me the process how to send a folder as a parameter in a script ( i h...
by rajan.n
Thu Mar 27, 2008 2:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Need a logic to pic a date attached file
Replies: 3
Views: 1106

Need a logic to pic a date attached file

Hello all,[:)] Hope some one throws some light [:)] my requirement. 1) Daily we get file name 20080424ABC.txt and 20080424ABC_XYZ.txt (date concatinated to the file name ) in to our folder say \\z\files\ 2)Now my job which reads "20080424ABC.txt " is with a seq file. I can not hardcode dai...
by rajan.n
Wed Jun 13, 2007 4:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Undefined symbol: .DSOpenProjectEx
Replies: 9
Views: 5588

Hi ArndW, i have run px jobs , but am sorry to ask abt transform stages, is this transformer stage..? if so we are using in many jobs.sorry if am wrong. yes am runing this script on AIX , on server. i aslo made a make file for creating the .o ans .so files for my c prog job.c, sucessfuly , that make...
by rajan.n
Wed Jun 13, 2007 12:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Undefined symbol: .DSOpenProjectEx
Replies: 9
Views: 5588

Hi ArndW, the command for -bloadmap is >/usr/vacpp/bin/xlC_r -b loadmap:a.txt job.c the a.txt file has the following : (ld): halt 4 (ld): setfflag 4 (ld): savename a.out (ld): filelist 7 1 (ld): i /lib/crt0.o (ld): i job.o (ld): lib /usr/vac/lib/libxlopt.a (ld): lib /usr/vacpp/lib/libC.a (ld): lib /...
by rajan.n
Tue Jun 12, 2007 11:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Undefined symbol: .DSOpenProjectEx
Replies: 9
Views: 5588

Is the project set up in PX so that transforms will compile and run? If yes, it would seem that the include file should import the definitions - can you try to add -bloadmap or -bnoquiet to the compile for additional information on why the DllImport didn't work as expected. Hi ArndW. Thanks for the...
by rajan.n
Tue Jun 12, 2007 11:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Undefined symbol: .DSOpenProjectEx
Replies: 9
Views: 5588

Instead of including the entire path of dsapi.h, try including just dsapi.h That says "can not find dsapi.h", have given the path of dsapi.h file. the dsapi.h is working fine- this i can know by folowing if i do include<dsapi.h> or remove that include i get teh folowing errors... DSPROJEC...
by rajan.n
Tue Jun 12, 2007 8:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Undefined symbol: .DSOpenProjectEx
Replies: 9
Views: 5588

Undefined symbol: .DSOpenProjectEx

Hi All I have a reqirement to use the DS functions in a c program, when i compile that i get the erors like " ld: 0711-317 ERROR: Undefined symbol: .DSOpenProjectEx ld: 0711-317 ERROR: Undefined symbol: .DSOpenJob ld: 0711-317 ERROR: Undefined symbol: .DSGetJobInfo ld: 0711-317 ERROR: Undefined...
by rajan.n
Thu May 24, 2007 11:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage API -c program.
Replies: 16
Views: 9935

Hi Ray, I dont mean u are wrong but, when a sequential file has processed , and other passive stages got processed in my test( with FULLSTAGELIST), why not only Dataset stage...?? @chullet, thnx for the reply. this is my trial .since the reqirement is urgent i have no other way to try. @all, if any ...