DSXchange

cc

bb

aa

aaaa

Hi Pandeesh,

Any helpful notes/considerations on Cobol ETL Logic conversion to Datastage Processes

Those are for earlier versions.

I am planning to capture batch load statistics like project name, job name, number of rows processed, run date, Status ( Pass/Fail). The goal is to capture each and every job part of master sequence stats has to be collected for audit purpose. Any ideas on this to start would be really helpful. Than...

version 7.5.2 ..UNIX AIX 5.3

Divya,

did you solve this situation? If so, specific details would be really appreciated.

"Not working" means unemployed. Can't help with the second one. The requirement is to connect to DB2 database using the odbc drives comes with the datastage product. Datasatge stages are working but need to do it through the scripting from the server. Any thoughts would be highly apprecia...

I am trying to do DB2 spool script...working for oracle

Trying to connect to DB2 database from datastage server using odbc drivers or db2 connect.

Either one is not working...Any thoughts on this....

Let me know, How did you do to get list of jobs?

Try to write that into sequentail file and load it from there..It's not optimum solution but it might work for your case.

ray.wurlod wrote:The DB2/API stage can communicate via DB2 Connect software to any DB2 on any platform. ...

You can even use odbc or DRS stage for any database, but these stages lower the performance.

Thanks guys. We have just started with teradata. In our case, we don't have existing utilites. we are planning to use utilities like fast load, multi load and fast export. Looks like, they are not available separately in TD V12.0

Let's me know, any helpful info from anybody.