Hi all,
how can I load an encrypted file? e.g.:
OUTPUT &vdatei ENCRYPT password
UNLOAD DATA FOR &vtab USING ALL AS ASCII
OUTPUT SCREEN
LOAD &vtab FROM &vdatei ASCII ??
Thanks
Hartmut Braun
A. Razzak Memon schrieb:
At 12:50 PM 2/16/2009, James Bentley wrote:
Razzak,
Thanks for calling attention to undocumented features of the
FORMAT function. At one time way back when either in old
documentation or in a discussion post the syntax to format
DATE and TIME variables was mentioned. If you access the
SET DATE and SET TIME commands you will find such key words
as MMM, MMM+, MM, DD, YY, YYYY, HH, MM (for time ), SS, AP,
etc. that can be used in the FORMAT function. Also, note
that the recent implimentation of "NN" as a replacement for
"MM" in time allows you to format DATETIME values.
The pleasure is all mine, James!
The ability to use FORMAT function to create file names and
more, without mucking with the connected database settings,
especially in a multi-user environment, is a cool function
of R:BASE!
Yes, the latest enhancement to support .#NOW System Variable
using FORMAT function enables a nice feature to create dynamic
file name(s) when defining automated database backup routines.
Since the introduction of this enhancement, I have been using
the following backup routine in my External Form File Timer.
The whole string to create a dynamic file name can be defined
in a "single" command.
-- Example
CLEAR VARIABLES vFileName
SET VAR vFileName TEXT = NULL
IF (CVAL('DATABASE')) <> 'RRBYW16' OR (CVAL('DATABASE')) IS NULL THEN
CONNECT RRBYW16 IDENTIFIED BY NONE
ENDIF
CLS
SET VAR vFileName = +
((CVAL('DATABASE'))+'_'+(FORMAT(.#NOW,'MMDDYYYY_HHNN'))+'.BKP')
-- Notice the "NN" for minutes when using .#NOW (not a typo)
-- vFileName will return the text variable as:
-- RRBYW16_02142009_1350.BKP
-- Date and Time will vary on your end
OUTPUT .vFileName ENCRYPT password
UNLOAD ALL
OUTPUT SCREEN
RETURN
Once the file is created, you may use "RBZip.RBL" Plugin to
compress the file and then FTP the entire backup file to a
secure FTP server using "RSFTP.RBL" Plugin.
The whole process is totally automated without human interaction.
Very Best R:egards,
Razzak.
____________
Virus checked by G DATA AntiVirus
Version: AVK 19.3194 dated 18.02.2009
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
