GET DATA /TYPE = ODBC
/CONNECT = 'connectionstring'
/UNENCRYPTED
/SQL = 'select statement'
unencrypted is the subcommand for the plain text pwd.
--jim
-----Original Message-----
From: SPSSX(r) Discussion [mailto:
[hidden email]] On Behalf Of
Trondsen, Norman(CDPH-CLPPB)
Sent: Friday, February 01, 2008 4:32 PM
To:
[hidden email]
Subject: ODBC Connect password
List:
The query wizard generates the following GET DATA statement for an ODBC
source I access frequently. It encrypts the password in the process. I
would rather the password be in clear text so it can be changed
periodically without having to re-run the entire Wizard. Are there ways
to accomplish this?
GET DATA /TYPE=ODBC /CONNECT=
'DSN=DHSPROD;UID=myidname;PWD=*D,h"l%u)D#-#!/-'
/SQL =
'SELECT "T558"."EMP_ID" AS "EMP_ID" FROM "HDHMSP"."V_ALL_OP_CLAIM1" '
'"T558"'
.
VARIABLE LABELS EMP_ID "EMP_ID".
Norm Trondsen
Research Analyst
Childhood Lead Poisoning Prevention Branch
CDPH - Richmond Campus
510-620-5655 (office)
510-816-5248 (cell)
=======
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command SIGNOFF SPSSX-L For a list
of commands to manage subscriptions, send the command INFO REFCARD
=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
Locked
