DSXchange

Hi Craig, Thank you for helping me with this. With help from your input, I was able to resolve this issue by doing the following: In the job sequence: In the Execute Command stage, I typed the following in the 'Command' box, \\servername\d$\DataStageProcessing\AFS\Output\TableCompare1.bat In the .ba...

Hi Craig, Thank you for the information. I checked errors on the server's event viewer and didn't notice any errors that coincides with the time I tried running the job sequence. Here is the content of the .bat file. type tableNotFound1.txt | find /v /c "ZZZZZZ" > alpha.txt Thanks again, S...

Hi Craig,
Thank you for your help. I just checked, the installation is also on D:\ drive but on D:\DataStage7.5 folder.

Seyed

Hi all, I am trying to run a .bat file from an execute command stage in a job sequence. I keep getting the 'The system cannot find the file specified' message. This is even after I fully qualify the file. Does anyone know what I am doing wrong? Here is what I have put in the 'ExecCommand' tab in the...

Hi Craig, Thank you for your help. For additional debugging, I hard coded a table name that I know exists within the schema and now getting the following error message: SchemaCompTablesPart2NEW..Oracle_OCI_125: ORA-00903: invalid table name SchemaCompTablesPart2NEW..Oracle_OCI_125.DSLink1: DSP.Open ...

Hi Ray, I tried adding backslash, and it failed with the following Fatal error: Project:AgencyWideReports (s99dws01) Job name:SchemaCompTablesPart2NEW Event #:476 Timestamp:12/2/2013 3:05:46 PM Event type:Fatal User:OKDHS\U74981 Message: SchemaCompTablesPart2NEW..GetSrcTblDDLBytes.IDENT1: |SchemaCom...

Hi all, I have a problem with passing arguments from a hashed file stage to an ODBC stage. What I am trying to pass is a list of table names, and for each table name that should be passed from the hashed file stage to the ODBC stage, the following SQL select stagement should execute and retrun the r...

All, I have a server job that the lookup fails due to sort problems. To isolate the cause, I simplified the job by limiting it to the source (ORAOCI9 stage), SORT stage, Hash stage and finally outputing to a sequential file. With or without the sort stage, the sort fails. I am already sorting the da...

Hi Andy, Thank you for your help. The problem with errors that I was getting has been resolved. The reason for this error was that I was assigning the 'Output to file' to the same file name as the first input file (#OFP##FILE_NM#). We changed the name to something like (#OFP#FILE_NM#.txt) and that r...

Andy, I just made the following changes, Command: copy /b #OFP##FILE_NM# + #OFP##FILE_NM2# #OFP##FILE_NM3# Output to file #OFP##FILE_NM# I confirmed that the first files were appended and placed into the 3rd file. Next, I would have to do something like move /Y #OFP##FILE_NM3# #OFP##FILE_NM# However...

Hi Andy, Appreciate your suggestion. I tried the following, copy /b #OFP##FILE_NM# + #OFP##FILE_NM2# output and then got the following error: DataStage Job 224 Phantom 5716 Program "DSP.ActiveRun": Line 51, Exception raised in GCI subroutine: Access violation. Attempting to Cleanup after A...

Hi all,
I have a server job that writes to two text files. I plan to append the second text file to the first. What is the best way to do this? A calling job sequence will be using the appended text file to email to assigned users.

Thanks,


Seyed

Changing global_names setting from 'FALSE' to 'TRUE' resolved this issue and our DataStage server job ran successfully.

For reasons unknown, the global_names parameter was set to 'FALSE' and it should have been set to 'TRUE'. The DBA changed the setting to 'TRUE', I tested the same INSERT in Toad, the insert ran successfully. We truncated the data in the destination table. The DS jobs have been restarted, we would kn...

Thank you for your input. Using Toad and SQL, we tried inserting data from Data Factory to Data Warehouse , the insert failed with "ORA-02069: global_names parameter must be set to TRUE for this opertion". We tried the same insert from our Data Warehouse, the insert succeeeded. It turns ou...