terrago
21.04.06, 17:00
W nocie 178949 jest opisane co zrobic na MS SQL'u aby mozna bylo z niego
ciagnac dane do BW.
Podany jest skrypt:
Here is an example for how to connect to another server with CON_NAME=BSK.
The example assumes BSK is running R/3:
EXEC SQL.
CONNECT TO 'BSK'
ENDEXEC.
EXEC SQL.
SET CONNECTION 'BSK'
ENDEXEC.
EXEC SQL.
SELECT db_name() INTO :DBN FROM SVERS
ENDEXEC.
WRITE: / 'current database name', DBN.
EXEC SQL.
SET CONNECTION DEFAULT
ENDEXEC.
EXEC SQL.
SELECT db_name() INTO :DBN FROM SVERS
ENDEXEC.
WRITE: / 'current database name', DBN.
Oczywiscie zmienilem to co nalezalo i teraz wyglada skrypt tak:
EXEC SQL.
CONNECT 'PLWARD07'
--ENDEXEC.
EXEC SQL.
CONNECTION 'PLWARD07'
--ENDEXEC.
EXEC SQL.
SELECT (LOADER) INTO DBN FROM SVERS
ENDEXEC.
WRITE: 'LOADER', DBN.
EXEC SQL.
SET CONNECTION DEFAULT
ENDEXEC.
EXEC SQL.
SELECT db_name() INTO :DBN FROM SVERS
ENDEXEC.
WRITE: / 'LOADER', DBN.
Skrypt wywala sie na linii:
"SELECT (LOADER) INTO DBN FROM SVERS"
Czy ktos z Was uruchamial go moze i moglby napisac jak prawidlowo powinien
wyglada ten skrypt.
Moj serwer to PLWARD07
Baza LOADER
Tabela (z ktorej chce ciagnac dane do BW) INVHEAD
Z gory dziekuje i milego weekendu
terrago
