Alter type script as automatic script after query event

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

IvanD
Posts: 8
Joined: Tue Sep 30, 2014 8:30 am

Alter type script as automatic script after query event

Postby IvanD » Fri Feb 13, 2015 1:24 pm

Hello,

Having ODBC source which is queried with opening .spq file.
The columns of this queries which are forming variables needs to go through script with alter type command.

The formats for alter type command of the variables can be retrieved from metadata table which
contain mappings from database data type to SPSS data type.

Query of the formats and forming the alter type script suppose to be executed at the end of the query from ODBC data source.

Need to prepare the script and automatic execution of this script on the event after queried data into SPSS sheet.


Grateful for any idea, suggestion or experience,

Who is online

Users browsing this forum: No registered users and 3 guests

cron