DSXchange

Thanks Ray

Just wanted to know 0X is hexadecimal value or it is something else

Hi

I am using one audit routine in that i am passing my parameters as

Stagename|linkname|TgtStage name| tgt linkname

is there any way to use the pattern based parameters

like : *_SRC_STG|*_SRC_LNK|*_TGT_STG|*_TGT_LNK

Thanks

I having the below problem in Director When I am opening the director it showing the error: failed to open RT_Log37 file the director list it is not listing one of the job(let suppose JOB A) and for one job(say JOB B) it showing error getting jobstatus I fired the query under datastage administrator...

you can read the entire data as one field with varchar and then funnel it and later use a transformer to segregate the data

i didn't get your point

hi deeplind07

for varchar it will work fine ....

yes SURA you are right that Int works on 0 but in the integer field i am getting few records like '' this can you please suggest how to handle that

Hi i have one sequential file1 ---> transformer----> sequential file2 in sequential file1 there is column A(nullable,integer) and i have records like this '12345' '23456' '' '456789' in transformer i am using if len(trim(link1.columnA)) = '' then 1 else 0 now when i am running the job or viewing the...

use TOP command in parallel window while running the job to find out the CPU utlization i think it will be more in your case

Thanks Narasimha,

i have uninstalled and installed again and now 7.5 is good :D

i think it is like

for example i have record
asdfg|asdghyt|bhgft65|njnjh;

here '|' is the record delimiter and ';' is the final delimiter

experts please correct me if i am wrong

Hi i had 7.5 and 8.1 both in my system today i uninstalled 8.1 and now when i am trying to open the 7.5 it is giving me the error falied to intialise the application resources for manager. this may be because version of this executable differ from the current datastage client version i think the 8.1...

you can use a below link

http://publib.boulder.ibm.com/infocente ... _Jobs.html

i think you can use the combination of isnotnull and len(trim(column))<>0

hi
for parallel you can use the stage variables
var1=link1
var2=if var1 = var3 then 1 else 0
var3= link1