DSXchange

Hi Kamal, As far as I know you can not import all metadata from excel to DataStage. What we have done in the past is the following: - Create an excel file having your field names in different rows (1 row per field). Then transpose those rows to columns (using paste special) - Once you have done this...

In the Manager, use Import > Table Definitions > ODBC Table Definitions to do the import rather than the ODBC MetaBroker. Also check the Show System Tables option. Neil. ----- Original Message ----- From: "Kamal, Zahid" To: Sent: Tuesday, November 19, 2002 8:42 AM Subject: RE: Getting started > Sui ...

Theres no convenient way to load file layouts directly from Word or Excel (or any other format for that matter) into DataStage. What you end up doing in importing the layout of the spreadsheet! If the source file has first line as column headings (or even if it doesnt) you can import the "table defi...

You are better off putting a filter onto your SQL statement in the Ingres stage so that you dont have to process the non 567 rows in DataStage. For this you will need an ingres where clause, if it is a text field try a Left function Left(empno, 3). If it is a numeric field you can use a number range...

Sui thanks for response. This is the message I am getting while trying to import from MS Excel ODBC database. MB_E_NOTABLES: ODBC30_DataSource_Accessor.cpp(223) No tables found. Please check the Schema/Owner name. Fatal Error has occured. Execution stopped. MB_E_ERRORTABLES: ODBC30_DataSource_Strate...

This is a topic for an orphaned message.

Seems interesting. But no share? Kasia At 07:31 14/11/2002, you wrote: >Hi Surendra, > >we have written a tools with which you can compile (and export and >import) jobs from the dos-command-line of the Ds-client-PC (even if the >server is UNIX). If you need more details, let me know. It is no free- ...

Hi Surendra, we have written a tools with which you can compile (and export and import) jobs from the dos-command-line of the Ds-client-PC (even if the server is UNIX). If you need more details, let me know. It is no free- or share-ware. Wolfgang -----Original Message----- From: Craig_Hulett@rsausa....

I wouldnt fault Ascential for this. Parameters are passed by reference, not value. When you pass @NULL (or anything else as a parameter) it has to store the value some place so it can send the address to the called function. When you assign a value to an argument, you are placing the data into the m...

Yes, you have found a bug ... in your code. DataStage function parameters are passed by reference. Why is your first routine changing the parameter? If it is by design, then dont pass the constant @NULL to it. -----Original Message----- From: Benoit_Murray@dmr.ca [mailto:Benoit_Murray@dmr.ca] Sent: ...

Hi all. For you information, we found the Bug ! Before calling the routine in problem... another routine was called and return 50 in the last argument (but previously passed to @NULL) and when we call the routine (in problem) @NULL have the value 50. Its look like @NULL = 50 ! Here is the problem: s...

Javi, I really appreciate your help. It worked. Abhijit -----Original Message----- From: Javier J Perez [mailto:Javier.J.Perez@transport.qld.gov.au] Sent: Wednesday, November 13, 2002 5:56 PM To: datastage-users@oliver.com Subject: Re: job being accessed by another user This has already been covered...

Could still be side effects occurring. Have you tried the technique of copying arguments into local variables? ----- Original Message ----- From: Benoit_Murray@dmr.ca Date: Wed, 13 Nov 2002 07:16:47 -0500 To: Subject: Re: Bug in a routine ... > > I determine this value because I insert these three D...

This has already been covered in the forum .. so to save some of the older heads the anguish of repeating themselves, Ill attach the advice given previously .... "Log on to DS server by using Telnet. Use LIST.READU EVERY to get all the processes in the server & get the user no for your job and use t...

Ask your DataStage administrator to release the job. --- "Bhattacharya, Abhijit, ALINF" wrote: > Hello Everyone, > I created and saved a Datastage job using Designer > from my machine. But by accident my network > connection went down. Now that my network is up, I > am trying to access the job. But ...