Problems with SQL SET statements
- From: Jonathan Ball <jonball@xxxxxxxxxxxxxx>
- Date: Wed, 30 Jan 2008 10:16:24 -0800
First, what is the difference between
set option sqlpath = *libl
and
set path = *libl
at compile time (V5R3)? If I do the former, user defined functions are not resolved; with the latter, they are.
Secondly, SET SCHEMA isn't working. I specify it before declaring and opening a cursor, but DB2 doesn't find the files in the cursor because it is looking for them in a library with the same name as my group profile.
.
- Follow-Ups:
- Re: Problems with SQL SET statements
- From: Jonathan Ball
- Re: Problems with SQL SET statements
- Prev by Date: Re: API QwpzHostPrintTransform failed : CPF3CF2 hptopt = 30
- Next by Date: Re: Problem with SQL UDF
- Previous by thread: API QwpzHostPrintTransform failed : CPF3CF2 hptopt = 30
- Next by thread: Re: Problems with SQL SET statements
- Index(es):