DSXchange

After my initial post, I discovered that the email body does not accept parameters (Parallel sequence) and instead simply inserts the hasehd parameter (e.g., #ParamName#)... so your suggestion to use a Server job will hopefully solve that part... I just have very little Server job experience... The ...

I have a basic 3 'stage' job sequence. 1) Job Activity - Executes a DS job that creates a TXT file containing an integer which represents the identifier of the just completed nightly batch run (works fine) 2) Routine Activity - Reads the integer from the above file (works fine) and, if the number is...

Does anyone know if there is any documentation on using the DTS stage with Oracle???... I've gone through the latest DS Redbook(July 2008) but since DB2 was the only option as that went to press, it does not provide any Oracle-specific information... neither does the DS QS Connectivity Guide for Dis...

We are getting the XML from an .XSD file via MQ... the .XSD file is as follows: ------------------------- <?xml version="1.0" encoding="UTF-8"?> <!-- $Workfile: ClassStaff.xsd $ $Revision: 2 $ $Date: 2/16/10 12:08p $ --> <xs:schema xmlns="http://schools.nyc.gov/DOE.Services....

Has anyone experienced problems importing XML table definitions in to DS 8.x???... is anyone aware of a known issue???... I'm trying to import an XML table definition and while the source is correct, it does not create the table definition... does the source file have to be .XML or should I be using...

Thanks to you all! It appears I have it working the way I want.

Thanks again.

I've been investigating how to do break processing within DataStage but have had no luck... here is what I need to do... From a single input source I need to group rows together by 3 key values (not a problem) then I need to assign an incrementing number starting from 1 and continuing to n based upo...

After researching the Information Server Administration Guide - page 59, I found the following which appears to reference the agents in the windows environment. '...IBM Information Server components: a. Stop the following services: ASB Agent, Logging Agent, DataStage Telnet Service, DSRPC Server, a...

Chuckd248, Since you said that you have no problems with DB tables, so that means your IA is up and running just fine. Your problem is only against the .txt file. That's why you need to bring in the QETXT.INI file in order to do the column anaysis against the .txt file. Browse your QETXT.INI file t...

Did you check to make sure both agents are up? If not, try the commands in my previous post to verify the agents are up. Are these Windows agents/services???... if they are, I do not see either 'LoggingAgentSocketImp' or 'AgentImpl' in Administrative Tools> Services... It DOES show 'Logging Agent' ...

Did you put your QETXT.INI file in the same directory with your .txt files? My IA installation is completely on my Windows XP desktop PC... the IA server and client are installed to my local C: drive... the source files are located in my local D: drive... When I set up the ODBC connection to access...

I am at a customer site... using IA 8.1... trying to run analysis against sequential text files (.txt)... Windows XP environment... I create the ODBC for the source... I create the data store, data source in IA... I go to 'Import Metadata' and 'Identify Next Level' where it DOES show me the Data Sou...