Re: Does SST does not support Variable length field in logical ?

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxxxxxxxx>]

two things, varchar is not char, as it begins with a binary value, so no,
sst in dds does not work
but, substr in sql on a view will work

also, you could use the fixed length system fields in that table for the
library and file names, then you could substring them. Since the system
names are 10 max, you should not have to use the variable length names
unless you ARE using SQL already.


===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified Specialist - iSeries Administrator
 -- IBM Certified Specialist - RPG IV Developer

"When I die, I want to die like my grandmother who died peacefully
  in her sleep. Not screaming like all the passengers in her car."

    - Author Unknown

----- Original Message ----- 
From: "Vengoal Chang" <vengoal@xxxxxxxxxxx>
To: "'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
Sent: Monday, September 01, 2003 11:10 PM
Subject: Does SST does not support Variable length field in logical ?


> Dear folks,
> I want to retrieve some information from system file QADBXTRIGB
> on V5R1: I create as following statement LF, but cannot compiled. The
> error message is
> CPD7616   : Keyword ignored because of error in list of values.
> CPD 7964 : Field on SST keyword must be character or zoned decimal.
>
>      A          R MXTTTR                    PFILE(QADBXTRIGB)
>      A            TFFILE             I      SST(DBXTBTNAME 1 10)
>      A            TFLIB              I      SST(DBXTBTLIB 1 10)
>      A            TTPGM              I      SST(DBXTBPGM 1 10)
>      A            TTLIB              I      SST(DBXTBPGML 1 10)
>
> And I check those fields in QADBXTRIGB all Variable length field, if I
> changed SST to other fixed length field, compiled no problem. Does SST
> does not support Variable length field ? Any help will be appreciated.
>
> Best regards,
>
> Vengoal
>
>
> _______________________________________________
> 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.
>