DSXchange

Hi eostic ,

Exactly this is repeating list. And first time we are implementing XML jobs.. I am trying to understand Best practices provided and forum for the help. I got some confuse on repeating elements, how to display same elements with different list of values.

Thanks for your help.

UsergroupId is the column, we needs to repeat this column 3 times. But it is grouping and showing only once in the output. Is there any option to show the same column 3 times in the output?

Thanks!

We have an issue in genrating a desired output in XML. Your help will be appreciated. usergrouplist\@usergroupid usergrouplist\@usergroupid usergrouplist\@usergroupid Desired Output <UserGroupLists Reset="Y"> <UserGroupList UsergroupId="CUSTOMER ID" /> <UserGroupList UsergroupId=...

Can anyone recommend another output vs using Excel that could be used with DataStage to create a formatted output file where I can protect certain values while allowing other columns to be enterable? Basically, something similar to Excel - where I can lock columns A, B, C and allow values to be ente...

I need to create an excel report from my datastage job. Is anyone aware of any tools that could help format a CSV file into an Excel file automatically? I need to use cell/worksheet protection as well as allow for data entry on the xls. I believe a Macro would need to be manually run and I will have...

I have a job that may create 2 sequential documents. I only want to attach either document if it has something like a record count > 0. Is there a way via the sequencer to use constraints for attaching a doc to an email notification? If the count is zero, I would not want to attach the doc. Not sure...

Thanks ray. Its working fine now.

Hi All, Actually I can able to import meta data from SQL server tables and able to connect the tables from the job. But when I am trying to view data or run job. I am getting the below error. DSD.BCIOpenR call to SQLExecDirect failed SQLSTATE=37000, DBMS.CODE=170 [DataStage][SQL Client][ODBC][DataDi...

I have Login with DSADM(Adminstrator). Last week I did the same. It works fine. Actually now I have refreshed/rewrite the complete project. Now I need to run the the routine again.

Hi All, I am trying to Convert ORAOCI8 stages to ORAOCI9 with the given routine(OCI8TO9.B) as per the instructions given. When I am trying to run a command RUN DSU_BP OCI8TO9.B in Adminstrator. I got a error messages like this. Program "OCI8TO9.B" : Line 136, CLEAR.FILE attempt on ready-on...

In .odbc.ini file is it mandatory to mention LogonID and password for the entries. Ex: [SQLServer] Driver=/dstage/Ascential/DataStage/branded_odbc/lib/VMmsss18.so Description=DataDirect 4.0 SQL Server Wire Protocol Database=db LogonID=uid Password=pwd Address=sqlserverhost,1433 QuotedId=No AnsiNPW=No

Thanks a lot for your infromation.

Hi All, I have exported whole project from production which is in DataStage 6.1.1. Now I have to import whole project to new Development server which is in 7.5.1.1. In this process I got a requirement to change the production database login information to development database login information for a...

sachin1 wrote:Please let us know how are you sheduling job, sequencer or through basic code in Job Control.
function.

Scheduling by using Sequence jobs only

Running jobs on specific days only. Weekly - Monday, Monthly - 6th day of every month