DSXchange

You are right actually it is a new table each run, due to the suffix Process_ID. But as i said, it is a repeatable job, so in case that one Process_ID has to be re-run, I need that drop statement. Currently my table action is "REPLACE" an changing it to "CREATE" with a explicitly...

Thank you for your answers. Of course I don't need to drop the Table in the first run. But how can I check within the Orcale Connector whether that table exists in the first run??? That would be a great help! :D Additionally I have to tell you that the name of table is changing on every run! It is l...

Hello, I have a repeatable Server-Job which runs up to now on DS V9.1 and returns in the first run for a Drop-Statement just an INFO ORA-00942. When I run the exact same Server-Job on DS V11.7 I get in the first run a WARNING ORA-00942. Is there a way to " Demote to Informational " for Ser...

Hello Franklin, for sure, neither the data not the copy book has errors. Both are running productive for long time, only the DS-Job to be created with CFF is new now. This is to replace a very old DS-Job written in DataStage-Basic, because we couldn't move this from server to parallel, due to too ma...

Hello Franklin, thank you and to be honest I could only read a snippet (the first lines) of rays posting, so I already did it like you said - I just wrote 01 once at the top. As you mentioned two possible reason, I should focus now on the first one. => How can I find out whether the occurs are the p...

Hi Ray.wurlod, thanks for your explanation, that makes sense to me and of course now the importer works :) But now I have the next problem, when I try to "view data" on the output register, I got following strange looking error message: ##I IIS-DSEE-TFCN-00006 15:13:35(001) <main_program> ...

AIX:
Linux: How can I change the setting on Linux to "en_US"?

Hello, here is a brief update about the issue discussed: - the problem is not solved yet - the DS-Admin loaded all 37 EBCDIC-codepages available on the Linux-server, but "brute-force" trial-and-error all of them brought no final result - one of the admin of the BS2000 Siemens mainframe (wh...

I am quite sure it is a coding problem. As far as I know, the binary InputFile is coded in EBCDIC.

I want to contact my DataStage-admin and ask him to install EBCDIC code-mapping.
What precisely should I tell my admin to do?
Where could my admin get the EBCDIC coding-maps from?

Thanks

On the new Linux-Server, we are running a C-written job, which checks the binary file, before starting with DataStage. We recompiled that job on Linux (because it was running on AIX before) and the result is clear, the binary file has now errors.

Good Morning asorrell,

unfortunately setting "Map name to use with stage" in the register NLS to "NONE" was not the solution. I get still that broken strange looking letters showed when I look at "view data".

Regards

Hi sjfearnside, thank you for your answer, I just read a litlle about "byte-Order" / "Endianness" in the internet. As far as I understand it, this could just be a problem when transfering data from one hardware to another using different endianness. In my case the transfered bina...

Yes, the old job still works on the old currently still active AIX-server with DS V7.5 server edition. - on the new server the job can be compiled with no error - anyway I exported the DS-Job from the old AIX-server and imported it to the new Linux-server a several times. But it doesn' t run correct...

Hello, I am involved in a process of porting a system containing several DS-Jobs from DataStage V7.5 Server Edition running on AIX 6.1 to DataStage V8.5 Parallel Edition running on SUSE-Linux. Migrating the DS-Jobs was running good so far, but I have now serious problems with a DS-Job written in Dat...