Need help? Email or Call Us: (952) 933-0609
Home › October 2009 Q&A

October 2009 Q&A

Submitted by Barbara Davey on Wed, 2009-10-21 14:41
in

Is there an easy way to select all the fields in a file and build an expression or two?

Yes, you can use a SELECT * statement, but be sure to qualify the all-fields asterisk with a file qualifier and continue the SELECT clause with an expression. For example:

SELECT *.1, CRLIM-AMTDU NAME(CRBAL) LEN(9,2)

FROM SEQUELEX/CUSTMAST

Need Help?

Talk to Us
In the U.S. and Canada, call 1-800-328-1000 and ask for Sales.
Elsewhere in the world, contact your local international office.