Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Select over OTG

Status
Not open for further replies.
WP

WP

Programmer
Nov 30, 1999
463
CH
Hi,

I am trying to migrate data over the OTG from DB2.

Some of my table have fields that contain SQL strings and the OTG is not coping with this.

e.g. sample record

OSMUSRFAV
FAVUSR='PATONWI'
FAVNAM='EXECUTED ORDERS'
FAVSQL='SELECT * FROM OSMORD WHERE ORDSTAT='EXECUTED''
FAVSRT='ORDREF DESC'

Anybody have any exprience of this?

W.


WP

 
Status
Not open for further replies.

Similar threads

Livia8
  • Locked
  • Question
Question re: SELECT DISTINCT 1
Replies
6
Views
918
SkipVought
S
Livia8
  • Locked
  • Question
SQL SELECT - where date is null or greater than 2
Replies
9
Views
4K
carp
carp
kernal
  • Locked
  • Question
If there is a Fee on Class Level then that fee overrides Fee on Course Level 1
Replies
3
Views
171
kernal
kernal
greatwhite1
  • Locked
  • Question
Selecting Duplicating records 1
Replies
8
Views
201
carp
carp
kernal
  • Locked
  • Question
Is there any way to write a select statement for distinct when there is a CLOB field? 2
Replies
4
Views
349
john parker
john parker

Part and Inventory Search

Sponsor

Back
Top