DSXchange

Thank for your message PaulVL. There was no issue(s) with command line by applying direct values in the command. The script giving result as expected. The issue persisting while applying the variables in istool.sh command with server_name/project_name. It was keep in failed and not accepting. Thanks...

Thank you PaulVL. Tried as mentioned but import process failed once again. Here is the result, Working Directory = /opt/ibm/datastage/InformationServer/Clients/istools/cli ./istool.sh import -r -dom dsserv1.de.intra.net:9445 -u 5157 -p 5157 -ar /user/backup/isx/ISX_*.isx -ds ' dsserv1/ETL_DEV ' ERRO...

Thank you PaulVL. Modified as mentioned but same error...

Good Evening. I am encountering issue while preparing import/export automization by using Istool in simple shell script. Need your help. Here is my few lines of program code, #!/bin/sh . . . domain=${ls_addi_named_var1} user=${ls_addi_named_var2} pass=${ls_addi_named_var3} etlServer=${ls_addi_named...

Thank you Ray. But the system need to capture those three entries from Unix script and write into log file. @Chulett: Yes exactly this is what happening. All log entries were able to capture but only these three entries were not writing into log file. Wondering if any specific dsjob option available...

Good Evening, I am having issue while capturing Data Audit from UNIX shell script and writing into a log. The script giving all log details of the job or job sequencer along with each link count. But the existing script was not capturing following particular job log. Tried dsjobs command to capture ...

Hello All, Good Morning. Currently I am developing a solution and need your suggestions for this business rule. My Input data is, INV_ID|TYPE|C_ACC_NO|I_ACC_NO 262894733|INVOICE|<NULL>|I80501 262894733|CUSTOMER|40458|<NULL> 262889640|CUSTOMER|48909|<NULL> 262890100|INVOICE|<NULL>|K7856 262890101|CUS...

Hello ArndW, From your message, "MachineA" has DataStage7.5.3 and Oracle 10 client version. "MachineB" has Oracle 11g database server and we're able to connecting with "MachineA" with MachineB as well. Now, we're going to un-install Oracle 10 client version in MachineA ...

Hello, Currently my project is running with Oracle 11g database with DS7.5.3. But the current server have client version is Oracle 10. Please share your ideas whether if can un-install Oracle 10 and install new Oracle 11g client version in DataStage7.5.3 server. Will the 11g client software is compa...

Thanks for your reply. Had already implemented in a server job but want to migrate this logic into server routine. Since I've the same concept using several times in my current architecture.

Hello All, I've a requirement to select max of department ID from Oracle SQL-query and store in a file. This kind of process implementing in my project many times with different query but the aggregation concept is same. Once the result stored in a file and calling the file from my job sequencer and...

Thanks for your response. Basically this job was designed very long back and the developer by that time has replaced from hashed-file to Oracle as lookups due to run-window issues. But now the issue came back :) Business rule is the same table we are calling as 2 lookups with the Veh_ID as 17 charac...

Thanks for your answers. Better will not go for Windows 7 :) with DS7.5.3

-Nag

Hello, Has anyone have an idea whether DS 7.5.3 client will work in Windows 7 OS? Please share your ideas. My current O/S is MS Windows XP professional SP3 and my client is planning to change my desktop OS as Windows 7. Have to confirm before changing the OS whether the DS version 7.5.3 is compatibl...

Chulett: Thanks for your respond. Basically as my requirement is match Input record with lookup COMPANY_NAME and <LKP>.COMPANY_NAME successfully with input record then derive <OUTPUT>.COMPANY = "O". Here my input record is having 7 fields ISO_COUNTRY3, NAME, ADDRESS1, ADDRESS2, ADDRESS3, A...