DSXchange

Hi,

which sql*loader path load is used in the oraocibl stage (conventional or direct path load)?

(DataStage v 5.2.2 on HP-UX)

Thanks

Kasia

Hi I cannot remember the exact error message, but we had similar problems. They were due to our french version of NT (of th at command, actually), while Datastage thinks American. Solution was: Edit the DSPARAMS file in the project directory. Add a section at the end of the file , to explain Ds what...

We were looking at Terminal Server, but we might have as many as 5 concurrent remote users. We were thinking that Citrix would help us manage that. -----Original Message----- From: David Barham [mailto:david@barham.hm] Sent: Tuesday, May 06, 2003 8:29 AM To: datastage-users@oliver.com Subject: RE: C...

Wasnt Windows Terminal Server derived from Citrix (or related in some way) in the past? We use the DataStage clients on a terminal server all the time. It is a great way to manage dial up connections. I havent yet had a chance to try it over the internet via VPN though. -----Original Message----- Fr...

Hello Group, Has anyone installed DataStage 6.x client tools (Director, Manager, Designer) or Integrity designer on a Citrix server? I can find out the exact version of Citrix server, but I wanted to see if anyone had experience first. We have developers in Hong Kong and Europe and the US that need ...

Hi, I have the error when I try to schedule my batch, I use an administrator user dsadm. This is the message error: "Error calling subroutine: DSR_SCHEDULE (Action=1); check DataStage is set up correctly in project caricamento_mis (Subroutine failed to complete successfully (30107))" Thanks all, Bar...

As I said earlier, this problem went away when the client software was re-installed. They also saw the problem in more than one project, and happened upon this "solution". YMMV. -- __________________________________________________________ Sign-up for your own FREE Personalized E-mail at Mail.com m

Technically its a property of the ODBC stages output link. You will find a check box there. As David suggests, you can also access the link properties from within the Transformer stage to which the link connects. ----- Original Message ----- From: David Barham Date: Tue, 6 May 2003 15:08:03 +1000 To...

Thank heaps, It is working now Cheers Jessica David Barham on 06/05/2003 03:19:17 PM Please respond to datastage-users@oliver.com To: "datastage-users@oliver.com" cc: (bcc: Jessica Nguyen/NSW/ING-MM/AU) Subject: RE: Many to Many datastage Change your custom query to: SELECT IN, FromDate, ToDate, ......

Thanks for your reply, But how do I make this a parameter because I have a list of #pIN#, #pFromDate# AND #pToDate# as a input data example: 12345, 2003-01-01, 2003-02-01 89895, 2002-12-01, 2003-04-01 ABCD,2000-01-01, 2003-01-01 Cheers Jessica amcguinness@qbe.com.au on 06/05/2003 02:19:02 PM Please ...

Change your custom query to: SELECT IN, FromDate, ToDate, ..... FROM TABLE WHERE IM_NUMBER = ? AND TRANS_DATE BETWEEN ? AND ? And set IN, FromDate and ToDate as key columns derived from the input record. -----Original Message----- From: Jessica.Nguyen@ing.com.au [mailto:Jessica.Nguyen@ing.com.au] Se...

4.2 has this feature. In the transformer stage, right click on the title bar of the reference link details and select properties. Obviously, you would pass your start/end dates or whatever as parameters to the reference link -----Original Message----- From: Jessica.Nguyen@ing.com.au [mailto:Jessica....

Hi, Thanks for your reply, How do I enable multi-row result , I could not find in the transformer stage, can you please send a example Currently we are using design of version 4.2 , does this version have the feature ? Cheers Jessica David Barham on 06/05/2003 02:04:56 PM Please respond to datastage...

Jessica Try using an ODBC stage where the sql predicates are passed into the DS job as a parameter along with the date range e.g. SELECT * FROM TABLE WHERE IM_NUMBER = #pIN# AND TRANS_DATE BETWEEN #pFromDate# AND #pToDate# I hope this helps. Adam Jessica.Nguyen@ing.com.au on 06/05/2003 01:51:01 PM P...

Enable multi-row result set on the reference link properties in the transformer stage. -----Original Message----- From: Jessica.Nguyen@ing.com.au [mailto:Jessica.Nguyen@ing.com.au] Sent: Tuesday, 6 May 2003 13:51 To: datastage-users@oliver.com Subject: Many to Many datastage Hi, What is the easiest ...