OK, I think I just discovered why ODBC and Oracle 10g won't work. It is quite simple: There is no ODBC driver for Oracle 10g. I've been using the Oracle Wire driver and it does not work. Maybe I'll try the non-wire driver just for kicks.
Larry
Search found 70 matches
- Wed May 31, 2006 9:42 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ODBC for Oracle 10g
- Replies: 6
- Views: 4987
- Wed May 31, 2006 9:23 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ODBC for Oracle 10g
- Replies: 6
- Views: 4987
- Tue Sep 13, 2005 11:52 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Reading Parameters From Database directly
- Replies: 14
- Views: 14886
'M_FTP_MXG2000_Read_Lnk.PARAMETER_NAME' needs to be the actual parameter name, not an input link which contains the parameter name. The parameter value would be read from the db in a db stage and passed into the Transformer where it can be accessed. And yes, you do need an output from the Transforme...
- Tue Sep 13, 2005 7:45 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error viewing data in Oracle9i stage
- Replies: 8
- Views: 4440
- Tue Sep 13, 2005 7:38 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Reading Parameters From Database directly
- Replies: 14
- Views: 14886
I have several jobs which do this. Use an appropriate db stage to read the parameters from the database. Then, in the Transformer have a derivation something like this: If UtilityGetRunJobInfo(UtilityRunJob('JobName', 'Parameter1=':value1: '|Parameter2=':value2 : '|Parameter3=':value3 : '|Parameter4...
- Wed Sep 07, 2005 6:51 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Upgrade ORacle to 9i - What change I do on Datastage server
- Replies: 5
- Views: 3245
Do the following: sign on as dsadm, then cd `cat /.dshome` This will take you to the dshome directory. dsenv is there. I would recommend making a copy before changing it. Remember that you must bounce the DSEngine in order for changes to dsenv to take effect. From the dshome directory: bin/uv -admin...
- Tue Sep 06, 2005 2:31 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Upgrade ORacle to 9i - What change I do on Datastage server
- Replies: 5
- Views: 3245
- Mon Aug 08, 2005 11:43 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: using .netrc with an FTP shell script
- Replies: 5
- Views: 3774
- Thu Jul 28, 2005 7:25 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: using .netrc with an FTP shell script
- Replies: 5
- Views: 3774
Thanks Ray for the suggestions. I really had not even thought about using the at command and was about to give it a try when I thought of one other thing. That was that it seemed that there must be some kind of environmental difference. After looking around it turned out that $HOME was not set when ...
- Wed Jul 27, 2005 11:45 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: using .netrc with an FTP shell script
- Replies: 5
- Views: 3774
using .netrc with an FTP shell script
What more can I say? The AIX shell script executes FTP on order to transfer multiple files from a Novell server, using .NETRC for user authenitcation. When run directly from a Unix command line, it works like a champ. When run from a job sequence Execute Command activity, it gets "Intruder Dect...
- Thu Jul 21, 2005 8:08 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: find/replace(Parameters) utility to promote to production
- Replies: 10
- Views: 5023
Actually you can use a text editor to change/replace encrypted passwords. We do it fairly often using UltraEdit (a Windows program). The trick is to know what the encrypted passwords look like. This is easily accomplished by writing a dummy job which contains both the old and the new passwords as en...
- Thu Jun 30, 2005 7:02 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Job aborts after 754K recs with Aggregator: %s
- Replies: 20
- Views: 8672
- Wed Jun 29, 2005 3:36 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Job aborts after 754K recs with Aggregator: %s
- Replies: 20
- Views: 8672
- Wed Jun 29, 2005 9:24 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Job aborts after 754K recs with Aggregator: %s
- Replies: 20
- Views: 8672
- Wed Jun 15, 2005 11:20 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Validate all the column data in a Table
- Replies: 9
- Views: 3790
1. Extract all (or some portion if you can predetermine what portion you will need) data from your target table and create two hash files: KeyHash with only key fields, and CDCHash with all fields (and with all defined as key fields). 2. To determine if a row already exists, do a lookup against the ...