Re: Embedded SQL Question

["Brian Johnson" <brian.johnson.mn@xxxxxxxxx>]

CRTSQLRPGI ... RDB(*LOCAL)

followed by

CRTSQLPKG

or

CRTSQLRPGI ... RDB(remote-database-name)

to create the package at compile time.


On 8/24/07, Robert Munday <rwmunday@xxxxxxxxxxxxx> wrote:
> This was forwarded to me by another programmer onsite:
>
>
> I am trying to connect to a remote using SQL but I get the following error message:
>
> call connect parm('pgpdd' 'xxxxxxx')
>
> Application process not in a connected state.
>
>
> Below is my statement in an embedded SQL:
>
> c                   eval      SqlStmtStr = 'Connect to S1008B4d user ? +
> c                                          using ?'
>
> c/Exec SQL
> c+   Prepare DynSqlStmt
> c+    From :SqlStmtStr
> c/End-Exec
>
> c/Exec SQL
> c+   Execute DynSqlStmt
> c+    Using :userid, :password
> c/End-Exec
>
>
> I also tried this embedded SQL statement:
>
> Connect to S1008B4D user :userid using :password
>
> Both of these statements work perfectly well in interactive SQL.
>
> I would appreciate any help you can provide.
>
>
> Robert Munday
> Munday Software Consultants
> Montgomery, AL
> on assignment in Nashville, TN
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.