DSXchange

Hey, Could not see anywhere you are doing DSRunJob. Where are you executing the job ? Generally it is a good idea to check the status of the job before executing, pasting a sample code : JobHandle = DSAttachJob("MY_JOB",DSJ.ERRWARN) errSetParam = DSSetParam(JobHandle,"JOB_TABLE_NAME&q...

Hi folks, I'm trying to create an xml. What i'm doing is getting data from an oracle table and trying to create an xml. I'm able to create the xml, but, for some reason, the first column is missing in the xml. i.e., if i have 8 columns defined in the table definitions, i'm getting only 7 in the xml...

DSguru2B wrote:Ray,
The link that I had posted is not for the website, but a unix directory path where the OP can find some examples to see from.

Hey DsGuru,

Thanks for the examples link. But I got the actual link for the actual pdf.

ray.wurlod wrote:I'm sure someone posted this link recently, to the eServices web site. Try a Search.

Yummy :D I was sitting on it, got to get my eyes checked, missed the blue ink !!

Hi, I am using Oracle9i and datstage 7.5 I want to read a table . The structure is like COMPANY_NAME VARCHAR2(100 BYTE), VISIT_DATE DATE, REPORT SYS.XMLTYPE When I try to read in datastage, I get Unknown Column type for SYS.XMLTYPE. This happens when I try to load the column definition for this tab...

swamiar wrote:It is an integer field of length 10.

Regards,

Aravind

But there is practically no way that ur sequence's current value will change unless nextval is called. Please check where u r using the sequence and actually how many times it is getting called.

Yes , what you can do is create a procedure to refresh the materialised view and call this procedure in the close command of your target stage in the job or call the procedure through datastage after the loading job finishes. Since your users will always be hitting the materialised view, they will s...

hello everyone, I am facing a problem with an extract query that works well in the sql developer. the oracle extract query goes like this.. select a.clm1 null as clm2 (clm2 is decimal) null as clm3 (clm3 is char) from a this query runs well in the sql but when it is run in the oracle enterprise sta...

Or load a second copy of the table and when the load completes, swap it in for the original. :wink: Exactly, this is called mirroring. It is infact pretty easy to achieve this through materialised views. Maintain a materialised view for your table and make sure that users always hit the materialize...

Please find the following: I gave ftp <servername> at the command prompt. Connected to <servername> 220 server_6 FTP server (EMC-SNAS: 7:45:33:2) ready. User: <username> 331 password required for <username>. Password: <I entered the password> 530 Login incorrect. Login failed. ftp> But whether you ...

Hi We are using the ftp stage to copy a flat file to a share drive. We gave the correct server name , our windows login ID/password. but when we run the job we are getting the following error. "Login to the FTP server failed, invalid password for user co10004" we are able to connect to th...

Before intervention of IBM, we were easily able to get if from http://www.ascential.com/eservice/pages/products/manuals/orchestrate.html. Not sure about now. Kumar, The link is not working anymore and I need to have the list of operators badly. If you have the operators guide and relevant material ...

Or do a lookup to the table2 for a dummy column with a value say '1'. You can check the lookup condition as give by you table1.a>table2.b and table1.a<=table2.c. In this case if there is a possibility of more than one record satisfying the condition, please do not forget to set the link name from w...

But it is not working if I remove the file from the root directory.Is it like some kind of bug or is it a mistake with the settings that i have done I have used direct path in the location property and it works (cant access DS right now hence cant tell u the exact name of the property). In my case ...

Amarpreet wrote:table1.a>table2.b and table1.a<=table2.c(in between condition)

You should not need a join condition at all and hence you won't need renaming columns. Achieve a cross join of the two tables and put a filter where you can specify the condition you mentioned.