DSXchange

Hi, Is there a course outline available? I'm hoping to get an idea of what will be discussed. Will there be like a server installation, conversion of existing server jobs to Px, etc? I'm planning to register soon but I want to know more about the lab and at the same time present it to my colleagues ...

Hi all.. I've a job which runs daily. This job invokes a stored procedure, passing a date parameter. Today's run took a long time (actually, the status is still running altho' nothing's going on). The DBA checked the DB and saw no activity on the SP. I saw this msg in the &PH& directory: /ap...

Hi vcannadevula, Your suggestion worked! :P We just did an upgrade to DS7.5.1.A in our dev server and started doing a shakeout on our jobs and got this error in 3 jobs so far: [IBM][CLI Driver] CLI0131E Invalid string or buffer length. SQLSTATE=HY090 SQLTables: Error retrieving system catalog inform...

Hi,
Thanks!

I tried your suggestion Ken, and it's working.

at095nb, how do I define InputRec?

Hi, I have a staging job which reads from a source sequential file (pipe delimeted) and then loads valid records into a staging table. The problem with the source file is, 2 or 3 records have incomplete number of columns. I want these rows to go to a reject file and only load those valid records in ...

Hi, I have a staging job which reads from a source sequential file (pipe delimeted) and then loads valid records into a staging table. The problem with the source file is, 2 or 3 records have incomplete number of columns. I want these rows to go to a reject file and only load those valid records in ...