DSXchange

When do we use the following when reading data
API stage and EE stage
Thanks,

Hi Andrw, Thanks for the thought and time. I did not get you when you say "the first pass gets all the possible file names into some list", so I am thinking, use a source XML Input Stage , then a XML Transformer and then ? how do I store the file names, basically the xslt will be generatin...

Hi Ray,
Is this still the case or are they out with the Plug in for SQL ?

Thanks,

Hi , I had a Oracle stage in server job which does update else insert, now if it was updating I did not want to update one of the columns, and it gives the same error ORA-01036: illegal variable name/number Can we not have different number of columns for update and insert statements in the same stag...

Thats a round about way of doing it, I had this situation before and it worked when I reset the array size to 1, have raised a case with IBM will post the solution if they come up with one, else will have to go the constraints way. Thanks and Ray do you happen to know of the reviews on advanced EE t...

Can you eloborate on
"So i created constraints in the transformer and explicitly asked the job to Insert or Update. "

I agree with "mouthou", it looks like a DS bug, even though I have the insert array soze as 1 instead of the default 500, my job aborts with the "ORA-00060: deadlock detected while waiting for resource" and my DBA is sure there are no locks .

Hi,
I am not looking for the surrogate key value, I am calculating DATE value in Job1 and need to pass it as parameter to the next job in a seq.

Exactly, even I am trying to get the format of the Input.txt file , hey sainath do you have one?

That would be helpful.
Thanks,

Trying to figure out what's the format of the Input.txt , we have 3 parameters param1, 2,3 .


Tried this format in the file ...
Param1
Param2
Param3


Does not work !

crontab I mean

Thanks a bunch , we are in the process of looking into all the corn tabs!

Hi Chulett,
Any ideas onhow to deal with

There is a job that runs between 1-2Am and that is our backup window time. Is there a way to find out which job it i s?

Have looked carefully in the director and there is none scheduled to run or jobs that spill over to 1AM.

Thanks,

Hi,
There is a job that runs between 1-2Am and that is our backup window time. Is there a way to find out which job it i s?

Have looked carefully in the director and there is none scheduled to run or jobs that spill over to 1AM.
Thanks,

dude,
I know where it is, I wanted to figure out if changing the routine is the best way to go or we do have a function !