I am validating the records from source data count with qvx data count.
Is there any way to find the count of qvx records.
There is the function
try with qvx ....let me know
QvdNoOfRecords does not support qvx files.
You should to load the qvx, NoOfRows('table1') will return how many rows were loaded
Hi Clever Anjos,
Let me clarify you here, I am getting Qvx files from infrormatica and I want to test it here itself. Once we get conformation then I have to move next step. this is my concern.
If you want to test if the file is there please use
if Alt(FileSize('file.qvx'),0) <> 0 then
load * from ['file.qvx'](qvx);
I´ve seen that you trying to do this using Linux (Re: Record counts in QVX file using unix)
grep -A 5 --binary-files=text "</QvxTableHeader>" y.qvx | wc-l
if result >2 there is data into that file
i tried with below command and getting result 6. but i have lot more records in that corresponding table
grep -A 5 --binary-files=text "</QvxTableHeader>" fact_lead_status_inserts.qvx | wc -l
You need the exact quantity of lines or just test if > 0?
This script is supposed to work, no warranties
f=x.qvx # your file, maybe you want to use $1
p=$(grep -n --binary-files=text "</QvxTableHeader>" $f| cut -d: -f1)
t=$(cat $f |wc -l)
echo `expr $t - $p`
LOAD Max(RecNo()) as NumberOfRecords
FROM your.qvx ...
Retrieving data ...