DSXchange

You need to split your input based on the column to be updated. The columns passed to the ODBC stage define the columns that will be updated. If you want to update each column individually without writing code, you need one output path for each column, passing the key and the column to be updated. I...

Thanks Kenneth, but that wasnt exactly what I meant.. Let me rephrase this: My input sequential file is a named pair file with three(3) columns, which is defined as: column to update,new value,ID of column key For example "FIRSTNAME","Pierre",1 "LASTNAME","DeVoer",3 "AGE","34",1 So my first value is...

Hi, We start to working with the extractor of SAP R/3, we can see the SAP tables, but when we try to generated the ABAP process it return the follow error ABAP/4 Syntax error Line=131 Offset=14 Error message = For type "C" a maximum length specificity 65535 is allowed There is anybody who can help u...

Thanks Doug. Leonid "Hall, Doug" on 07/26/2002 12:32:00 PM Please respond to To: "datastage-users@oliver.com" cc: Subject: RE: Job resources clenup Kill -9 is typically a last resort to kill a process. If the Universe commands do not work, always try a simple "kill" command without the "-9" option. ...

Kill -9 is typically a last resort to kill a process. If the Universe commands do not work, always try a simple "kill" command without the "-9" option. That option does not allow the process any cleanup. At this point, you may need to stop / re-start the DS Engine. -Doug -----Original Message----- F...

I killed a job using "kill -9" command. Now I have this PID # displayed in Job Resources window as unavailable. I tried to cleanup resources, clear status file, unlock resources, but nothing works. Any suggestions?

Thank you,
Leonid

I agree. Access Database very tedious to use - even if opened with the "Shift" key on and never could really update my Access database. And unusable with Oracle indeed (unfortunately!). We never use this tool, and produce manually some excel sheets Good luck, Kasia At 03:49 26/07/2002, you wrote: >T...

Thank you! Denzil Sander on 07/26/2002 11:04:15 AM Please respond to To: datastage-users@oliver.com cc: Subject: RE: InfmxCLI I asked the same question, and Ive been told that somehow the driver is used differntly for each connection. I do however know that the CLI is much faster than the ODBC, I pr...

I asked the same question, and Ive been told that somehow the driver is used differntly for each connection. I do however know that the CLI is much faster than the ODBC, I presume its because of the direct communication with the database, and no translator such as odbc. From the manual: Currently, y...

What is the difference then in .odbc.ini for ODBC and CLI since we have the same driver? It is pointing to the same host, Informix instance and database... Leonid Denzil Sander on 07/26/2002 10:33:19 AM Please respond to To: datastage-users@oliver.com cc: Subject: RE: InfmxCLI Yes, the ODBC and CLI ...

Yes, the ODBC and CLI use the same drivers - and I still dont really know why. I currently have a call logged with ascential with regards to the informix cli not working on our current setup - solaris 8 with datastage 5.2r1. Are you sure your .odbc.ini is set up correctly for the connection? -----Or...

What I mean by "hosing" universe is that the job eats up all the resources and brings the universe database to its knees. We end up in having to reboot the machine to get things back to normal. Whats really puzzling is that this job runs every 4 hours and only causes this problem once or twice a wee...

The data model is fairly straightforward, and can most easily be seen by having MS Access perform a Relationships analysis, then dragging things around. The hierarchy falls out pretty straightforwardly based on the number of columns in the tables keys. At the top level there is the project. At the n...

The MS Access database that gets loaded when you run the Reporting Assistant can be accessed directly rather than by the verbose reports that ship with it. Try locating the Access database (doc_tool.mdb - see doco for location) and opening it with the "Shift" key pressed. This will open the MS Acces...

Well, there is always the dreaded Reporting Assistant and Documentation Tool. It gets (optionally) installed with the client and is used to pull selected portions of your project in an Access database. From there, you can print reports detailing every aspect of your jobs / routines / etc. Problem is...