#13064: Parameterized Script: User would like to declare a variable and use it in a filename for export

SachinPrakash reported 2015-01-28T17:05:34Z · last modified 2015-02-20T22:57:23Z

Parameterized Script: User would like to declare a variable and use it in a filename for export

Dev	kin-hong
QA	tariqrahiman

Priority	Major
Complexity	Unknown

Component	Q Analyzer - Parameterized Scripts
Version	15.0

We try to do a select and declare a date-variable like that way:

SELECT * FROM database_files

go

DECLARE @PartOfFilename datetime

SET @PartOfFilename = GetDate()

go

This syntax is not supported in ADS. Enhancement request is to support the below query in ADS.

select * from bi

.saveResults 'Format=Excel,

Source=Grid,

File="/Users/s/Downloads/results_\&PartOfFilename={d}.xls",

Overwrite=true,

IncludeChart=false,

IncludeHeader=true,

IncludeNullText=true,

IncludeRowCount=false,

IncludeSQL=true,

AlternateRow=false,

AlternateRowBackground=#f8f8f8,

AlternateRowForeground=#000000'

4 attachments

3-File.png

2015-01-28T17:06:41Z

60 KB
results_'2014-11-21' (1).xls

2015-01-28T17:06:41Z

4 KB
1-Query.png

2015-01-28T17:06:41Z

39 KB
2-Parameters.png

2015-01-28T17:06:41Z

67 KB

All Comments (2) Change History

SachinPrakash 2015-01-28T17:05:42Z

Change from Kin-Hong:

1. In AFSession.java the single quote is skipped if we are in double quote context

tariqrahiman 2015-02-20T22:57:23Z

Verified in ADS v15.0.14-6

Search Tips

Aqua Data Studio / nhilam

Parameterized Script: User would like to declare a variable and use it in a filename for export

4 attachments

Issue #13064

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Parameterized Script: User would like to declare a variable and use it in a filename for export

4 attachments

Issue #13064

Completion