DSXchange

Certain products (particularly database products) have the annoying behaviour of inserting their executables directories at the beginning of PATH, presumably to maximize their performance at the expense of everything else. (Wouldn't you, in their place?) It's always a good plan to review PATH (and t...

This might be a need to get the user name right. Have you tried: username machinename\username domainname\username Did all three fail? Try connecting via telnet (Start > Run > telnet machineID); your Windows authentication should be OK here. Select the UV account. Shell out to the operating system w...

Pivot stage to do the pivot.
Use constants in the pivot stage to generate the month names.

Create a routine that writes the XML document as a field-mark delimited dynamic array. Just before returning, convert the field-marks to line-terminator characters. Because you're on UNIX: FUNCTION CreateXMLDocument(Args) Equate LF To Char(10) XMLDocument = "" * your code h...

Most unusual! ATTRIB is a DOS command. Open up a CMD.EXE shell and type ATTRIB /? to find out more. It's usually located in Could it be that your PATH environment variable has been amended so that %WINNT_ROOT%\System32 isn't in it?

Copyright law, for starters. Unless you were prepared to give away your copy. I suspect the legal eagles could (would) find some prohibition against resale.

The project on which I'm currently working uses solely unterminated text files. The line terminator property is on the Stage tab in the Sequential File stage. Its only requirement is (obviously) that the records are in fixed width format. It's OK that there are multiple record formats (as we have he...

That you can do. Choose File > Print, then the Print to File check box.

Welcome aboard! :D Can you be a bit more detailed with your specification? The easy solution would be to construct a shared container containing a Sequential File stage and an output link. The Sequential File stage can specify a Filter command; this could (perhaps) achieve your binary-to-text conver...

Look at the entire error message. IM002 is the "SQL State", a generic ODBC error code that can almost always be ignored if further information is provided. [DataStage] is the vendor of the client software [SQL Client] is the name of the client software [ODBC] indicates that the ODBC driver manager w...

You'll probably need a custom operator if you want a "pure" PX solution. If you're prepared to use BASIC, which slows PX down somewhat, the solution is easy using Oconv. If TheNumber < 0 Then "-" Else "+" : TrimF(Oconv(TheNumber,"MCN":@VM:"MD2,")&#...

I think Ken meant "thrashing" when he went with "trashing".

But, since he lives in the hurricane state (Florida), who knows?

UniVerse is a trademark of International Business Machines Corporation. Note that not all "tables" in the following list are full SQL tables with security and integrity constraints. Most are hashed files of some kind. UniVerse SQL System Tables UV_SCHEMA schemas UV_TABLES tables UV_VIEWS views UV_AS...

Yes, but then there's all the other ones, like VOC, VOCLIB, &*& in the project, lots more in the UV account, more again in the SQL Catalog, and so on. And there are some (like UV.LOGINS) that only occur on Windows. That's why I sought to clarify what information is actually sought.

Is /tmp becoming full during processing?