Use SELECT Queries Safely in AIQ SQL

I

Use haveSELECT anQueries Safely in AIQ SQL

script

When thatusing hasAIQ a 'select * ...' line. It failsSQL in Scenario Editor.

Editor

or Resolution:
related Thetest-data userworkflows, needprefer explicit field lists over broad SELECT * patterns. Explicit fields make tests easier to usemaintain properand SQLreduce syntaxfailures (everywhen SQLschemas change.

Recommended query style

• Select only the columns needed by the test.
• Use clear aliases when values are mapped into scenario steps or DPL fields.
• Filter to the smallest safe data set for the validation.
• Avoid logging sensitive values in shared output.

Troubleshooting

1. Confirm the query runs in the approved database client or validation environment.
2. Check quoting rules for the database engine usein differentuse.
3. Review syntaxwhether specifications),special ifcharacters are being interpreted by AIQ, the userdatabase, is using MySQL as your engine make sure to use single quotes for table names and schemas, same for all ofor the othershell/script SQL data base engines.layer.