DSXchange

In a server job or in a BASIC Transformer stage you can use the SDK Transform MeasureAreaSqFeetToSqMeters. Detail of its transform definition: (%SqFeet% * .09290) Otherwise just multiply by the constant. Make sure that the Sq Feet value is not null and is numeric, so as to prevent errors. Since squa...

I recall a presentation at an IOD conference (2008?) in which the presenter made the point that there aren't really any best practices that have universal applicability, though you could argue for a set of "least worst" practices. There are three key concepts, as I see things: don't do any...

Use the UNIX sort command or a third-party sort utility such as CoSort or SyncSort.

If the column(s) by which the data are to be sorted or indexed using a B-tree index, then sorting is at no cost because a B-tree index is stored in sorted order.

You can not avoid sorting data unless the data are already sorted, because you must first have the keys grouped. Unless you want to compare "this record with the previous record" irrespective of keys. In either case, set up two stage variables. One compares the current row with the previou...

Umm... compile in trace mode and import THAT into production?

You have to build that in. test.sh must echo anything returned from bteq and exit with the bteq exit status. The exit status can be detected through the fourth argument of the DSExecute subroutine; the output, including whatever you generated with echo statements, through the third argument.

None of this information is available in the "UniVerse" tables. (You can search DSXchange for DS_AUDIT; DataStage does not use UV.ACCESS and UV.ACCOUNT is the central registry of existence and location of projects.) User login is recorded in operating system or Active Directory.

But you CAN pick and choose your rows using a Filter command such as grep.

Actually, you *could* pick and choose columns as well by shifting to an External Source stage and using something like awk or sed.

kishorenvkb wrote:I cannot see anything that Ray wrote as I am not a member. Hopefully the members got some benefit out of this conversation.

Thanks anyways!

Your problem is easily remedied.

None, once you've updated any DataStage credential in Information Server that is mapped to dsadm.

You can perform a "console more" installation (command line option -console) to avoid the need to use the graphical user interface.

Do you have the DataStage deadlock daemon running? It usually cleans up orphan processes (though this can take up to about 30 minutes to detect and kill them).

AIX does impose a limit of eight characters. There is a command to waive this constraint, but by default it is there.

To make things even uglier, the limit is not enforced if the password change is effected by the superuser (root).

Welcome aboard. There is an Installation and Upgrade guide (PDF) on your existing system, that contains full instructions. Otherwise go to IBM web site and search for "InfoSphere Information Server Installation Instructions" to get links to all installation topics. This is probably a good ...