DSXchange

Thanks a lot for replying Kandy.

Could you please specify the location where i can ds_nls_Off.bat and ds_nls_On.bat files?I couldnt find these files in the projects folder.

Please pardon my ignorance and advise.

Thanks
Sue

Hi, As part of migration from 7.5 server to 8.5 server, we have imported and exported jobs on a new server(DS8.5) and as expected we encountered oracle plugin issues where we manually changed OCI8 to 0CI9 and compiled the jobs on new server. It worked fine(compiled and executed) on development serve...

Thank You Ray. We will try that and let you know if we can acheive it in that way.

Sue

Hi,


How can we pass parameters in a job sequence? We changed in the sequence job but it is not overriding the dependant jobs.

Appreciate your help.

Thanks
Sue

0000000 S D S 2 2 M M S D S b u s h 5344 5332 324d 4d20 5344 5320 6275 7368 0000020 i n g 2 2 m m I D 302 274 k 696e 6720 3232 6d6d 2049 4420 c2bc 206b 0000040 e y 6579

Hi Ray, BY using the command od -cx for the line SDS22MM SDS bushing 22mm ID ¼ key, i got the following output: 0000000 S D S 2 2 M M S D S b u s h 5344 5332 324d 4d20 5344 5320 6275 7368 0000020 i n g 2 2 m m I D 302 274 k 696e 6720 3232 6d6d 2049 4420 c2bc 206b 0000040 e y 6579 0000042 Plese he...

Hi, One of your jobs is failing daily due to a special character in the input data where we need to manually delete that special character and loading the data. Eg: Input data : SDS22MM SDS bushing 22mm ID ¼ key I guess, the input source might have had the data as A to the power of 1/4 and during...

Hi,

When we try to export the jobs from DS 7.5.1A Server Edition version and import them to DS 8.5 Server edition version, we are getting following error message for some of the jobs during the compilation stage.

Stage Type Object 'ORAOCI8' not found

Please advise.

Thanks
Sue

Yes. We dont have PX licensed as well.

But creating 600 jobs takes a lot of effort and time. I guess it can be done using SQL scripts using minus operator. But it will surely eat up server resources.

Thanks
Sue

Thanks Chulett for your response. I have already implemented CRC32 in my previous projects and have an idea on it. But we have got around 600 tables to compare and if i implement CRC32, i would be constructing 600 jobs to accomplish that. Is there any other easy way to do so?

Thanks in advance
Sue

Hi,

Here we are loading the same data in two different tables in two different servers and we would like to compare the data in those tables and see if everything is fine and load the mismatched data into another table.

Thanks
Sue

Hi,

As part of our testing phase, we would like to compare two tables with identical structures in two different servers.

Please suggest any optimal way of performing this using DS server edition.

Thanks in advance
Sue

Hi, The installation and moving of the files have been completed succesfully. We are able to start DS services on the server. But we are getting an error while connecting through client: Getting following error message: Failed to connect to host: cusncd01, project: UV (The connection was refused or ...

Thanks so much Chulett. We will think about it if we start facing any issues. We will keep this post updated.

Thanks
Sue

Thanks Chulett. Since the file in the solaris server has got the default values hashed out and included new values, i am in the perception that we need to change the default values in the new AIX server as well. We didnt move the file from solaris to AIX yet. Thanks for the heads up. Thanks again Sue