Also I was able to get tinycobol to read MYSQL with a
command line call (both single records and multiple
records) but I am looking for a way to get directly to
MySQL.
READ-ACCOUNTS-RECORD.
INITIALIZE WS-SYSTEM.
STRING 'mysql -ppassword database -e '
'"select '
'username, '
'useremail, '
'userdata '
'from theusertable" > /rodfile'
delimited by size
INTO WS-SYSTEM
END-STRING.
CALL "system" using WS-SYSTEM.
The "insert into" will also work to put a delimited
file into MySQL.
Rodney
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
|
