DSXchange

Hi Can you help me? I have an error on a Job Server reading from a SQLServer 2000 via OLEDB Stage. The error is: OLE DB provider error HRESULT=0x80004005 The support of the customer for which I work now suggested to me to use an ODBC driver access. It is this suggestion correct? Thank you very much ...

Hi I have a fact table which is going to have around 2.5 billion records in the first load and after that around 20 million records in the subsequent loads. Can anyone give an estimated time it will take to load the 2.5 million records. The Source and target are both in DB2. The mappings are not so...

Can I use the function DSGetJobInfo to get the category in which a Job is saved?

Thanks in advance

Umberto

ArndW wrote:There is no recovery from a deleted job - the delete removes the job and all the contents immediately. ...

I supposed that. Thank you very much.

umberto

Hi

a simple question. How can I resume a Job accidentally removed from the repository? Is it possible? I've no backup, of course.

Thank you

Umberto

Create two jobs: OCI-->XFM-->SEQ and SEQ-->XFM-->OCI. You'll see how fast the data spools, and how fast the data inserts. As for the PL/SQL argument, she's lost it already. It would be faster to use straight DML, because of parallel query processing capability. "INSERT INTO target.table (...) ...

If the table yesterday was partitioned one way, and today is another, obviously the data had to be ported from the old copy of the table because the partitioning key has changed. That being said, the new method for partitioning may have shifted the data around differently. Comparing yesterdays load...

Hi I need of an help about this question. I'am working for a Customer asking me to create a Job Server with DataStage 7.1 to read a flow of data from an Oracle Table and to insert the rows extrected into an other Oracle table. Both tables are partitioned, but the customer for me has committed a mist...

Hi, thank you for your answering. I have followed Arnd's advice and it works well. But I haven't understood what do you say. I only want to know if I can read from the Repository some information such as "the job name calling a qualified job", for example a Job batch executing a Job Server...

I'am sorry but I have another question for you. How can I embedded this query in a Universe Stage? How can I connect to the Repository by a DataStage Job Server, if it' is possible? Is there the possibility to connect by an ODBC driver? If yes how can I install it?

Umberto

You are an angel. Thank you very much. It is exactly what I was looking for.

ArndW wrote:Try "echo %DATE% %TIME% > filename.dat" ...

Ok, it works. Thank you very much

Umberto

ArndW wrote:Umberto,

just as with date /t you can use the time /t command to get the current time output in dos. ...

Ok, but if I want write togheter and not only one?

If you used the metadata for the table "pippo" in your job design, you can go to the Manager and right-click on the table definition and do a usage analysis to get the list of jobs that have used that ... No, the customer don't use metadata. So the only way to do that is querying the repo...

touch.exe ships with DataStage. It can be found in the Engine folder's bin subdirectory. ... This is the command I used in a Unix environment. I can't access this subdirectory. I have decided to use the command suggested "date /t > filename.dat". If I want to write in that flat file the c...