DSXchange

Thanks for all your posts and assisstance guys, the virus issue was the main problem. issue resolved.

hi, there doesn't seem to be any log file created for the run and no error files are being created either in the Scratch area. the only error message i get is the one regarding the log file which it can't find. i wonder if something has changes with the configuration or something along those lines, ...

Hi,

Looking at some previously generated log files they just contain table information and rows loaded etc so i'm not so sure if it will hold any key information as to why it's not being loaded.

has anyone come across this error before.

i shall certainly search for the file as you suggested

Hi, Im currently trying to load into a Oracle table from a dataset but receive the following error: The call to sqlldr failed; the return code = 32,768; please see the loader logfile: E:/IBM/InformationServer/Server/Scratch/ora.7416.323000.1.log for details. Although it says see the above log file, ...

sorry, my mistake, i just needed to format the target file with pipe delimited. the output now is as follows :

col1 col2
a
a aa
a bb
a cc
b
c
c dd

so just need to emilinate the a and c that have col2 as blank somehow

hi,

i tried that but got some odd results.

Output column

DSLink3.f1 : col1
EReplace(",":DSLink3.f2,",",Char(10):DSLink3.f1:"|") : col2

reults as

col1 : col2
a
a|aa
a|bb
a|cc
b
c|dd"


col2 is empty

sorry, it has more but i'm just using two as an example here as i'm only bring two columns across in the transformer. once i had this working then i was going to build it up

thanks

sorry, it has more but i'm just using two as an example here as i'm only bring two columns across in the transformer. once i had this working then i was going to build it up

thanks

sorry, it has more but i'm just using two as an example here as i'm only bring two columns across in the transformer. once i had this working then i was going to build it up

thanks

hi, i know this has been discussed many times before and i am using a previous example from this site that i searched on but i am getting quite odd results. my source file is: a|aa,bb,cc b| c|dd the results i am getting is a|aa a|aa b| c|dd c|dd and i require a|aa a|bb a|cc b| c|dd probably somethin...

thank you very much, that worked.

sorry, i want to place a Pipe delimiter not a Tab.

thanks again to all, for your advice, i shall give that a go.

thanks again to all, for your advice, i shall give that a go.

sorry for the previous ex, the order in the derivation should have been col2, col1

if i do it as col1, col2

i get this:
1 aaaaa
bbbbb