You specify a library on file SDW_V/VIP_SOURCE
But not on file envmstv5
Library list?
-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Brian
Garland via RPG400-L
Sent: Friday, August 20, 2021 7:08 AM
To: rpg400-l@xxxxxxxxxxxxxxxxxx
Cc: Brian Garland <Brian.Garland@xxxxxxxxxx>
Subject: Embedded SQL issue
I've got a weird SQL problem. A static SQL statement in an RPG program
returns an SQLSTATE of 02000 but when run from STRSQL (or run SQL
statements) I get a result.
I've verified the value of the host variable on the where clause and
substituted that when running manually.
SELECT TIMEZONE_ID, DST_RULE_ID, SOURCE_LABEL, USE_DST_FLAG INTO
:ID_TIMEZONE, :ID_DSTRULE, :s1Source, :s1UseDST FROM SDW_V/VIP_SOURCE JOIN
envmstv5 ON source_code = ad_environment_id WHERE appdtaa_library = :CusLib
FETCH FIRST ROW ONLY
Any suggestions?
--
Brian J. Garland
Vermont Information Processing, Inc.
brian.garland@xxxxxxxxxx
--
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or company to whom they are addressed.
Do not disclose, distribute, or copy this email to others outside your
company. If you have received this email in error, please notify the sender
immediately and delete this email from your system.
--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit:
https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
