RE: PASS *BLANK TO VARIABLE ?

["Ellsberry, Steve" <steve.ellsberry@xxxxxxxxxxxx>]

You don't pass it you assign the value to a variable then use the variable
in your sql statement. For example:

/Free
  A=*Blank;
/End-free

/Exec Sql
C+...
C+ Where fieldnameforcompare = :A
C+.....
/End-exec

-----Original Message-----
From: Luqman [mailto:pearlsoft@xxxxxxxxxxxx] 
Sent: Wednesday, February 16, 2005 3:40 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: PASS *BLANK TO VARIABLE ?

How can I pass *BLANK to a Variable in SQLRPGLE, in the middle of an
SQLRPGLE ?

I tried following but it did not work out.

C               EVAL         A=*BLANK


Any idea please ?

Best Regards,

Luqman




--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.