Re: Filenames for Writing OutputFiles

[Adrian Nuttall <nuttalla@WILLISCORROON.COM>]

I have been using SQR on an NT box using Windows 95 and I have found no
restrictions in file length.  I believe the file length will be limited by
your operating system.  e.g. Win95 limits you to a total of 256 characters
for the file and the path.
An example of the files I have been writing out are...

x:\PS_Import_Files\DUP_25-Jan-1999_043021PM_VOUCHER_LINE_P.txt

from the code...

!
! Define the DateTime variable to avoid a ':' in the file name
! ------------------------------------------------------------
!
  Date-Time () DD-Mon-YYYY_HHMISSPM &Time
  Let $VarDateTime = &Time

!
! Set the name of the duplicate file
! ----------------------------------
!
  Let $file_dup = '{VOUCHERPREFIX}' || 'DUP_' || $VarDateTime || '_' ||
'{VOUCHER2FILE}'

Hope this helps

Regards

Adrian Nuttall
nuttalla@williscorroon.com

__________________________________________original
message_________________________________________

Date:    Tue, 9 Feb 1999 14:25:38 -0500
From:    Mark Kraft <kraftm@GUNET.GEORGETOWN.EDU>
Subject: Filenames for Writing OutputFiles

Is there a limit of characters for file names that you can use when
creating file names for flat files, for instance,
let $filename = 'MJKTEST.DAT' works fine, but
let $filename = 'ACCT' || $fiscal_year_rc || $acct_period || $sysdatetime
||
'.DAT' blows up.
let $file = '{fileprefix}' || $filename
open $file as #out for-writing record=200 status = #stat_read

I am assuming that there is an 8 character limit, but I cannot find
anything
of this nature in the manual, so I figured I would post it here.  Please
let
me know if I am confined to 8 characters.  Thanks for the Help

Mark Kraft
kraftm@gunet.georgetown.edu