Gossamer Forum
Home : Products : DBMan SQL : Discussion :

DBman and AS400

Quote Reply
DBman and AS400
I hope someone can help me with this question.
1.I have an AS400 server with data on in.
2.I export this data into a .txt (approximately 16,000 records) file
3.This data will be exported daily...
4.Have DBmanSQL serve as the interface to display this data
5.Can DBManSQL do this?
6.Also can DBman authenticate and direct users based lets say on two fields(user,pass) from this data to the appropriate information...their information?

Any help or suggestion would be greatly appreciated.

Thanks in advance...

Quote Reply
Re: DBman and AS400 In reply to
In Reply To:
Can DBManSQL do this?
Yes...you could write an add-on script that will IMPORT the text file into the appropriate tables. Using MYSQLMAN, you can view the source code and mirror its IMPORT features and run the add-on script via Cron or Windows Scheduler depending on what OS you have and what web server you are using.

In Reply To:
6.Also can DBman authenticate and direct users based lets say on two fields(user,pass) from this data to the appropriate information...their information?
Don't really understand your question...but if you are asking can users signup an account and then add, modify, delete records, then yes...If that is not what you mean, then you will definitely have to be more specific.


Regards,

Eliot Lee