Re: Need to determine which version of a file a program has to work with

[Dennis <iseries@xxxxxxxxxxxx>]

Normally I would use QUSLFLD API for that information.  But since you're already in SQL, DESCRIBE may provide quicker result.  (?)

"Charles Wilt" <charles.wilt@xxxxxxxxx> wrote:

> All,
>
> I've got a need for a program that can work on two different versions
> of a file.  Specifically, in one version of the file a particular
> field is 10a, in the other it's 7p 0.
>
> The program will be using SQL, so level checks aren't an issue.  But I
> still need to know which version I'm dealing with so I know which
> statement to run.
>
> We've come up with the following methods to determine which version of
> the field is available
> 1) IBM API's
> 2) SQL Describe
> 3) Looking at SYSCOLUMNS
>
> Any pros/cons to the above?
>
> Does anybody have any additional ideas?
>
> Thanks!
> Charles
> -- 
> 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.

--  
Sent from my Galaxy tablet phone with with K-9 Mail. Please excuse my brevity.