DSXchange

Hi everybody.

How do I obtain a list of all SQL statements from my jobs?
I mean, the SQL statements that are inside "DB2 stages".
I need to list them.

Thank you guys!

Best Regards,

Hi guys.
When I try to set the Clear Log configurations it shows the following message:
"Unable to return an attached Job
Cannot open file RT_LOG".

This job is Compiled and not running.
I noticed it happens with all jobs.

Any tip?

Best regards,
Joyce

I noticed something interesting.
When it returns more the one row from the Procedure, only the first one maps the input fields to the Output, only the first row has values to these fields.
The other rows, don't. They are empty.

Why?!

Is it a kind of bug?!

Thank guys!

Hi! I have 5 fields at the input. 3 of them, I use as parameter, the others I just want to map the values to the output. And at the output should exist these 2 and the 7 that return from the procedure. It depends on the register, sometimes the values maped to the output appears, and sometimes is emp...

Hello Guys! I have a problem. I am using the Stored Procedure to connect DB2 database and there are some fields from Input tab that I want to map do Output and these fields are not used at the Procedure. I checked the "Forward Row Data" option at the input tab to achieve this result but so...

Thank you Ray for complementing.

Yeah, now I have a lot of work....

Hi everybody! I worked for a project to migrate servers. At the old one there were only server jobs and routines in basic, it was not the Enterprise Platform. This week we are observing the processes at the new server in which runs the Enterprise platform v.8.5 and the same servers jobs and basic ro...

Ray,
I run these queries you mentioned against VOC and DS_ROUTINES.
They returned one line but where is the routine code, which really interests me?

Thank you very much.

priyadarshikunal wrote:Can you check if there are any stray locks present in is console having same session id?

No, there is not, my friend!!

Thankssss

If you want to recover, you can create that folder and put 6 required files to the folder as described here . Then run ISALite to recover the VOC and other stuff. Actually my friend I don't have any of these 6 files. But this project that I created is an empty one, I mean, there is no job or anythi...

PS. the routine is not native, it's a user one.

Hmmm... nice!!

Thanks, Ray.
Could you write me exactly the query I should run?
Thank you so much.

xxxx,

Hi my friend!
That was exactly what I needed.

Thank you very much!!!!!


xxx.

Best Regards,

I found the problem guys!
The thing is that the file .odbc.ini was in a Windows format, with Windows 'end of lines': char 13, char 10.
When we changed it to Unix format, the job worked!!!

Tks guys for your help!