sql import vanuit as400

[clipto]

ik ben bezig een import te doen vanuit een as400 database.
hier moet een aantal tabellen in een sql database gezet worden.
De huidig werkende syntax staat hieronder:

select "ADNUMM","ADNAAM","ADNAAM1","ADADRE","ADPOST","ADMAIL","ADWWWA","ADWOON","ADTELE","ADFAXN","ADGROE","ADVERZ","ADREKA","ADHREK","ADHFDD","ADVNIV","ADVNCR","ADDLOR","ADDLRG","ADDLPI","ADREMB","ADKOPI","ADBTWP","ADDMAG","ADAANM","ADVERT","ADKOST","ADPKON","ADAFLE","ADVKON","ADAFLV","ADKPRO","ADPRYS","ADPADR","ADPPOS","ADPWOO","ADGRBN","ADDGRB","ADTAAL","ADKDBT","ADDKRE","ADLKRE","ADDCYK","ADCENT","ADBEGD","ADDEBN","ADOPAD","ADOPFK","ADAUTI","ADVALV","ADSELK","VERKBHDJ01","MARGE","VERMEUDJ01","MARGE01","VERMACDJ01","MARGE02","VERICTDJ01","MARGE03","VERTDDJ01","MARGE04","VERTOTDJ01","MARGE05","VERKBHVJ01","MARGE06","VERMEUVJ01","MARGE0101","VERMACVJ01","MARGE0201","VERICTVJ01","MARGE0301","VERTDVJ01","MARGE0401","VERTOTVJ01","MARGE0501","VKDATO04","DATUM03" from "S654D44B"."OMZETTEN"."STAMBEST"

maar... en nu komt het.
er staan tientalle spaties achter iedere uitkomst in de nieuw gemaakte sql database.
nu bestaat er een trim commando, echter heb ik geen idee hoe deze exact werkt...
dus wie o wie helpt me uit de brand?

 

[beheer25]

Trim werkt heel eenvoudig. RTrim(veldnaam) levert je een string op zonder spaties aan de achterkant. Die worden er gewoon afgehaald. Met LTrim wordt hetzelfde trucje aan de voorkant uitgehaald.


Grtz,

 

[clipto]

select ADNUMM, RTRIM(ADNAAM) AS ADNAAM, RTRIM (ADNAAM1) AS ADNAAM1, RTRIM (ADADRE) AS ADADRE, RTRIM (ADPOST) AS ADPOST, RTRIM (ADMAIL) AS ADMAIL, RTRIM (ADWWWA) AS ADWWWA, RTRIM (ADWOON) AS ADWOON from S654D44B.OMZETTEN.STAMBEST

dit was de goede syntax, in combi met de omzetting naar nvchar. :thumb: