DSXchange

No - There is no such dependency. This sequence will be automated through scheduler -Which ever country file is created first will get the priority. We have a country code parameter at sequence level to differentiate. We would have created separate sequence for each country. But in future, we ould b...

Hi Everyone, We need to design a sequence in such a way that it execute only required jobs and not all attached to that sequence. Sample Job Flow in Sequence. Extract --> Transform A1 --> Transform A2 --> Load Say, Our Sequence is designed to process data for 2 countries A1, A2. So, when it is runni...

The Issue was that it was using the default 64-bit Internet Explorer (once we installed a patch) as earlier it was usng the 32-bit, I believe, since it was working fine

We opened the link in 32-bit IE and it worked as expected

http://<ServerName>:9080/ibm/iis/console/index.jsp

Hi, We have V8.7 on Wondows 2008 R2 After logging on the Server that hosts the Information Server, when we try to login in the Information Server via the Web Console shortcut..it is not doing anything (does not go anywhere) when we hit the "Done" button after entering the correct credentia...

By Not working I mean it does not update the record when we pass the Invocationid to be used as part of the Where Clause (We verified it is a valid value and should update 1 record) I already tried using the single quotes around it, as you suggested, but then it treats that as a string value and doe...

Unfortunately, Removal of the extra slash also did not worked.

Thank you!

I confirmed and we have required SSH created. But Still the job is running long without any activity. There is not sign of grabbing or extracting the data from Mainframe.

Can someone please confirm, if the above mentioned syntax are proper ?

Regards,
Synsog.

Hi, We are using FTP enterprise stage to connect and grab a file from Mainframe host. This connection is working perfectly fine when we are trying FTP using our own credentials. But somehow it's not able to grab the file using SFTP SSH connection URI - FTP://HOST//'MAINFRAME_FILE' TRANSFER_PROTOCOL ...

Hi All, We have a scenario where we update the same audit table and column across multiple processes for different values in where clause, once when a Sequence job starts and finally as the last step when the Seq job ends. The only change in the update query across different seq jobs is the value in...

Resolved this issue by creating the SYSTEM DSN from this path : C:\Windows\sysWOW64\odbcad32.exe instead of the default C:\Windows\System32\odbcad32.exe as we are in a 64-bit Windows Env. Then when I try to import the metadata using the ODBC Table Definition I am able to see the Excel file name but ...

Hi All, We are on V8.7 on Windows Server 2008 R2 Standard (64 bit) We installed the Microsoft Excel and Access Drivers on the Engine Tier (Office 2010) and then created a System DSN for this Excel Driver accordingly. Then I tried opening an .xls file on the server and it is able to open it so I beli...

Thank You both for your help. This is very helpful

Hi All, V8.7 on Windows with Engine Tier on one Server and Services/Metadata Tier on another. We will have a Datastage project say PRDEV on this Env and on this same box (Environment) have another project called PRPROD..So basically both Dev and Production projects will reside on the same box..I und...

The Password is Correct and Not Expired..It works if used directly

Hi All, When I run a job using dsjob and passing the user and password with other relevant infomation it runs successfully. dsjob -domain <Domain> -server <Server> -user uid -password pass -run -param Parameter_Set_Test=STAGE dstage1 JobName Then I try to run the same job but pass an Encrypted passw...