topic Re: ERROR [42000] Incorrect syntax near '*' in App Development

ERROR [42000] Incorrect syntax near '*'

Silvio — Thu, 13 Feb 2025 15:05:32 GMT

Hello everybody,

I'm trying to extract data from MS SQL Server with data editor and following script:

LOAD *;
[DE01_SFA1_CarrierUsage]:
SELECT*
FROM DataMart.dbo."DE01_SFA1_CarrierUsage"

STORE * FROM [DE01_SFA1_CarrierUsage] INTO $(v10_DatenExtraktion)/$(vFolder)/DE01_SFA1_CarrierUsage.QVD;

Error message is:

ScriptErrorDetails: ERROR [42000] Incorrect syntax near '*'.,

ScriptErrorList: Files has wrong format

Debugger has red marked the underlined line above.

Previous data extraction with following script works - I do not understand the problem.

LOAD *;
[DE01_SFA1_PseudoNIO_Transformed]:
SELECT*
FROM DataMart.dbo."DE01_SFA1_PseudoNIO_Transformed"

STORE * FROM [DE01_SFA1_PseudoNIO_Transformed] INTO $(v10_DatenExtraktion)/$(vFolder)/DE01_SFA1_PseudoNIO_Transformed.QVD;

Is there anybody who can support, thank you!

Re: ERROR [42000] Incorrect syntax near '*'

Oleg_Troyansky — Thu, 13 Feb 2025 15:32:44 GMT

Hi,

I believe your SELECT statement is missing the closing semicolon. I'm surprised that the previous data extraction worked without the semicolon - it shouldn't work.

Also, I'd place the table name [DE01_SFA1_PseudoNIO_Transformed]: before the preceding load - if nothing else, for a good logical view. The preceding load that does no transformations at all, is redundant. You can safely remove the statement and declutter the view.

Cheers,

Re: ERROR [42000] Incorrect syntax near '*'

marksouzacosta — Thu, 13 Feb 2025 16:49:38 GMT

Hi @Silvio,

Try the code below. My changes are in bold:

[DE01_SFA1_CarrierUsage]:
SELECT *
FROM DataMart.dbo."DE01_SFA1_CarrierUsage"
;

STORE [DE01_SFA1_CarrierUsage] INTO [$(v10_DatenExtraktion)/$(vFolder)/DE01_SFA1_CarrierUsage.QVD](qvd);

Note: you don't need that LOAD *; at the beginning of the code.

Regards,

Mark Costa

Re: ERROR [42000] Incorrect syntax near '*'

Silvio — Fri, 14 Feb 2025 06:34:41 GMT

Thank you Mark! It works now.

Regards,

Silvio