How to verify data from UNIX file

[syhusain]

Hello,
I am new to QTP and working on script that need to compare data from UNIX file with DB tables. Could someone help me confirm if QTP allows UNIX file data comparison with DB.

[deepaksporty]

Hi,

First of all QTP directly does not allow UNIX operations
Here is what I can think of:

1. First of all you need to ftp data or files (ASCII mode) to Windows text file and then make it compatible with windows file structure. Unix does not have CRLF.
2. Then you need to Connect to Database which you're using. may be copy the data which you need to compare in a variable or file
3. Use vbscript's string manipulation functions to compare data.

let me know if that helps
Deepak