DSXchange

Hi Chulett,
if it is only the tnsnames.ora then i have no further question.
I expected that i would have to update several datastage environment files.

Thanks a lot !!!
Manfred

Hello,
thanks for your feedback.
I read it several times, but it is still a riddle, what you wanted to tell me.
My hope was, to get i possible more detailed answers, especially, which entries in which are necessary.
Manfred

Hello, we have a well running system with connection to an oracle database. (this was not setup be me). Now i have 2 questions, and i didn't find an answer by searching in this forum up to now: 1) Is it possible to have connections defined to more than 1 database? So that i could read data from a ta...

Hello ArndW, well, i have set the NLS-parameter als listed above in the dsenv and after that started Datastage again. Those parameter appear in the Director Log as expected. Sorry, i don't know where to specifiy such parameters in the Oracle Stage ... What i wonder is especially, that i can see the ...

Hello, i want to use an environment variable in a parallel job. I have defined a user-defined variable in the Administrator. When i use this variable in a parallel job as a Parameter and set default to "$PROJDEF" it works! But when calling this job by a sequence i don't know whether: - the...

Craig, thanks for feedback. My main concern was, to damage any still needed files. No i will do the deletion by any unix commands.

Andy, currently it is not planned to go to 8x.

Thanks a lot !!! Manfred

Hello, i found accidential tousands of files (collected over the years) in a &PH& folder. I have searched in the forum already, for housekeeping e.g. the &PH& subfolder for a project. I always find a hint to the CLEAR.FILE command. I understand, this is a manual on demand task. But i...

I understand, that there is no smart solution within Datastage.
I think, i will use a SAS-Stage within Datastage and do a kind of pre-processing with SAS-coding and write an output file which will be used for further processing with real Datastage steps.

Thanks for your support/feedback.
Manfred

Hi Pagadrai,

thanks a lot for your feedback!
The main reason for posting this issue was, that i expected, that there is an easy solution within Datastage, but i simply don't find or don't know it.

Has anybody else any idea, how to solve this problem?
Best regards
Manfred

Hello, i have tried and searched for hours, and i don't find a solution! I have the following type of data input: Record-Id, Field-Name, Field-Value 1,Name,Hagedorn 1,Age,50 2,Name,Schmitz 2,City,Hamburg 2,Income,50000 3,Name,Meier 3,City,Berlin You see, not all columns are always available for each...