DSXchange

changed code to if Arg1 = "Y" then Call DSSetUserStatus("Y"); Call DSLogInfo(Arg1,"Arg1"); Call DSLogInfo(DSGetJobInfo(DSJ.ME, DSJ.JOBNAME),"userstatus"); Ans = 'Y'; END ELSE Call DSSetUserStatus("N"); Call DSLogInfo(Arg1,"Arg1"); Call DSLo...

hey i think i find part of the problem, the job can compile now. new the problem is the routine never return 'Y' even argument Arg1 is 'Y', but in the test window if i specify the Arg1 is 'Y' then the routine returns Y

i call this routine in basic transformer stage derivation area

Hi I have searched the form regrading to set userstatus but I still can NOT assign value to it! I create a transform function type server routine the code as following: if Arg1 = 'Y' then Call DSSetUserStatus("Y"); Call DSLogInfo(DSGetJobInfo,"set_userstatus"); Ans = 'Y'; end els...

how to reference the password value from parameter set into db sequence password filed in PxSCD stage?

I created a PxSCD data connector and load it in my scd stage but job gives me incorrect user name and password error unless I hard code the password into that field, bloody hell!

thanks
Abyss

it can be seen on IGC

grrr, the problem happened again
now the log shows oracle connector will run in parallel on 1 processing nodes. but still shows 2 connections on database side......

ok, i created new config file and make first node to ORACLE dedicated node, so oracle stage should only use that node for the job. let's see what happens......

yes chulett. i have talked to DBA this morning, he can't find any deadlock, blocking locks or whatsoever on database and that's why i felt a bit helpless, the only thing he could find was there were 2 insertion sql processes on this table it may cause the problem and this is confirmed with SURA's op...

yep it is parallel (auto partition), i was thinking parallel could be the problem.
you mean change the whole job to server job? then the dataset wouldn't work then, so change the dataset to sequential file?

hi all: I have a very simple job that load the data from data set and insert around 300 thousands rows into oracle table: data set ---------> oracle stage the job suspended after insert 150 to 250 thousands rows, suspend means stage stop inserting new rows and it doesn't return any error or warning ...

Hi I can not delete an empty host on IMAM. there is no asset under nest it. it shows the following message: [CDIMR2306E] You cannot delete a host that contains other assets. You cannot delete a database domain, physical domain, or data item definition if the metadata repository contains database col...

no never, but it is a bad approach anyway. we stopped using it now

To enable deletion of import areas in which imports were shared to the metadata repository, the Common Metadata Administrator must select Allow users to delete import areas in which imports were shared to the repository on the Import Settings page of the Administration tab in InfoSphere Metadata Ass...

hi hi all, i am trying to get current year value from transformer stage, the way i do it is: DateToDecimal(CurrentDate(),"%yyyy") and it output warning message： APT_CombinedOperatorController(1),0: Conversion error calling conversion routine decimal_from_date data may have been lost does a...