"Swetha" <[log in to unmask]> wrote in message
news:863821d4.0412022255.6e7af890@posting.google.com...
> Hello,
>
> I am using this simple script to extract a field from the database,
>
> BA TIGDB.TIGDTA,1,<pswd>
> GET ORD-ITEM
> IF ORD-SEC-NUM == "963361211846"
> SORT ITEM
> EXT QTY-CU-SHIP
> OUT ORDNUMFL
> XEQ
> Y
> PRINT ORDNUMFL
>
> THE PROBLEM IS, ALTHOUGH I CAN VERIFY THE PRESENCE OF TANGIBLE VALUES
> FOR QTY-CU-SHIP WITH ASKPLUS, THE OUTPUT OF ABOVE IS A BLANK FILE WITH
> RECORD NUMBER EQUAL TO THE NUMBER OF ENTRIES. THE DATATYPE OF
> QTY-CU-SHIP IS J2, WOULD THAT BE A PROBLEM? THIS IS NOT WOTKING FOR
> ANY J2 IN MY DATASET BUT FOR ALL OTHER DATATYPES. PLEASE HELP.
>

You are extracting a binary field, but printing it as though ascii. If you
want it converted to ascii, specify so on the output command:
  out ordnumfl,ascii

If you don't want to convert its format, then make the output file
self-describing, and use Suprtool to list it:
  ....
  out ordnumfl,link
  xeq
  in ordnumfl
  list standard
  xeq

M GoLD

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *