Midrange News for the IBM i Community


Posted by: clbirk
can one create a logical over a portion of a field
has no ratings.
Published: 18 Sep 2013
Revised: 20 Sep 2013 - 1909 days ago
Last viewed on: 11 Dec 2018 (2927 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

can one create a logical over a portion of a field Published by: clbirk on 18 Sep 2013 view comments(5)

I have some db tables that it would be desireable to create a logical that is over a portion of the field.

Example, say you have zip code and address 1 and what you want is zip code + only 10 positions of the address.

Creating the tables in SQL (well in inav). Going to use in rpg.  Can one do such?

 

 

Return to midrangenews.com home page.
Sort Ascend | Descend

COMMENTS