Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Hollis
Contributor II
Contributor II

'Unexpected token' error - Upgrade from QV 11 to QV12

Hi Guys,

I used the subroutine to stored files in csv-format, the related scripts is as below:

STORE * from [$(aTable2Store)] into $(vQVD_TRA)\$(aTable2Store).csv (ansi, txt, delimiter is ';');

It works well in QV11, but when run in QV12, it shows the error message.

Error: Unexpected token: 'ansi', expected one of: 'qvd', 'txt', 'qvx', 'delimiter'.

Anyone can help?

Thank you very much.

Labels (1)
1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

QV12 is more strict on syntax. "ansi" never was a valid keyword for STORE, but QV11 tolerated (and ignored it). QV12 does not. 

-Rob

View solution in original post

4 Replies
joseph_morales
Creator II
Creator II

Hi @Hollis 

You must delete the ANSI

STORE * from [$(aTable2Store)] into $(vQVD_TRA)\$(aTable2Store).csv (txt, delimiter is ';');

Regards

 

 

Best Regards,
Joseph Morales
Hollis
Contributor II
Contributor II
Author

Hi Joseph_Morales,
May I know the reason for this? Since it works well in QV11.
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

QV12 is more strict on syntax. "ansi" never was a valid keyword for STORE, but QV11 tolerated (and ignored it). QV12 does not. 

-Rob

Hollis
Contributor II
Contributor II
Author

Thanks a lot.