Search found 3 matches

by millea1
Tue Dec 04, 2007 5:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: User-defined SQL file problem
Replies: 2
Views: 1645

Yeesh. :? ...Does that help? To be honest, I was a little thrown off by your 'feeding it' comment, to me that implies using this on the target side rather than the source side and I'm not sure that makes sense. Yes that helps immensely, thanks! Cleared up lots of confusion on my part and things are...
by millea1
Thu Nov 29, 2007 8:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: User-defined SQL file problem
Replies: 2
Views: 1645

User-defined SQL file problem

Have a Oracle OCI stage with update action: User-defined SQL file. Have the file path in the 'Table name' box. The fatal error I receive is: 'User defined SQL is a required link property' I tried placing the file path in the User-defined SQL tab as another post suggested but in that case received th...
by millea1
Tue Nov 27, 2007 5:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error in routine- not in VOC
Replies: 13
Views: 6249

I'm getting this same error so am wondering if this was ever resolved? the parms, e.g. username/pswd/etc. are all 'hardcoded' code: cmd = "sqlplus -s hardcodeuserid/hardcodepswd@hardcodeDBname << EOI" cmd<-1> = "INSERT INTO hardcodetablename VALUES ('hardcodestring', 1500);" cmd<...