Re: DDS help please

["John Candidi" <jacandidi@xxxxxxxxxxxxxxxxxxxx>]

Create a query of the first file.In it create a result field using the 
DIGITS(INVOICE NUMBER FIELD) then take the result field and concatenate 16 
zeroes to it like this
0000000000000000||result field..Output to a file containing the second result 
field, then run your job
  ----- Original Message ----- 
  From: Greg Wenzloff 
  To: midrange-l@xxxxxxxxxxxx 
  Sent: Wednesday, July 13, 2005 10:52 AM
  Subject: DDS help please


  We have a simple query on a file containing invoice information. The
  invoice number is the key value and is a numeric 6 field with no
  decimals.

  I now need to add one piece of info from another file.  My problem is
  that in the other file the invoice number is stored left justified in a
  22 character field.

  I studied the DDS manual that says I can convert character to numeric if
  the characters are all digits but I can't come up with the logical file
  that will compile.

  I can use SST(char_22_field 1 6) and get a 6 character invoice number
  but that does me no good with the joining of the 2 files in query.

  Can I create a logical file with a 6 digit invoice number from the 22
  character field in the physical file?

  Thanks,
  Greg 

     

  -- 
  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.