DSXchange

You still need an If construct to handle the leading sign, since this needs to be prepended AFTER the formatting. For example: If input.amount < 0 Then "-" : Fmt(Abs(input.amount)*100000000,"R0%18") Else Fmt(input.amount*100000000,"R0%18")

I'm running non-NLS this week. Can I get back to you next week, when I can check this out on an NLS-enabled machine?

Multi-instance is relevant only to server jobs.
Parallel jobs' multiple instancing is automatic based directly on the configuration file (and the processing resources specified therein).

Hi Neil. Alas, the answer is an unqualified NO. The message about the RPC not being started is returned from the server. Even though you're connecting (trying to connect!) to different servers, the problem is that the ActiveX control that exposes objects used by DataStage clients in version 6.0 is i...

Dear All, I have a Job called (LOADLRRPoolOpics).We are running that job using DataStage Director assume(Job ---> Run Now Option)...I know that we can schedule this job using Menu Opt(Job ---> Add to Schedule). But I want to do that Programmatically(DS Programmint),Ray could you please help me on t...

Mahesh, Your most recent round of questions suggests that you are in need of the DataStage Essentlals class (DS314Svr or DS314PX). As a general rule the Sequential File stage is the fastest for writing. Using the DB2 bulk loader stage, though, gives you the means automatically to invoke the bulk loa...

You have created an Informix database without logging. Therefore, this database cannot support transactions. If you want to support transactions in an Informix database, you must create the database WITH logging.

Would you believe "it's a feature, not a fault" ?!!

I did read something about this recently (the sort being performed automatically), now where was that?...

It may be even simpler than that.

If you already had Designer open, its view of what's in the Repository was as at the last time it was accessed, opened or refreshed. It may be sufficient just to choose Refresh from the View menu in Designer (or its shortcut key, Ctrl-R).

It depends on the target database. Do it the same way that you would for the target database. For example, if the table contains columns AN1, C1, C2 and C3 (where AN1 is the autonumber column), you would either: INSERT INTO table(C1,C2,C3) VALUES (?,?,?); or INSERT INTO table(AN1,C1,C2,C3) VALUES (0...

Yes you can but not using a hashed file stage. A hashed file stage accesses a hashed file via its hashing algorithm, which processes the primary key value through a function that delivers the physical address where the record is located. It can only perform "=" searches on a primary key value. If th...

Hi, I have the following questions:- 1. Currently I am doing a Performance Testing in a Job which inserts data into the UDB DB2 Stage serially as well as parallelly.The Question is When I load data serially the performance is faster but when I use the parallel laoding the performance slow compared ...

You can use ED, you can use REVISE, you can use SETFILE (see other thread), you can use INSERT (which you may find a little more familiar). INSERT INTO VOC (F0,F1,F2,F3) VALUES ('APM.VERSION', 'F', 'APM.VERSION', 'D_APM.VERSION'); To determine the updatable column names for VOC: LIST...

This is why, whenever I am installing/upgrading a client, I grab all the Docs from the Packages folder (and any PACKs) and put them in the same place as the other manuals. At least I can always find them!

You need to check on the ETL server. At run time, the DataStage program looks to Oracle just like any other Oracle client (such as PL/SQL or TOAD), so must have all its "client settings" correct. The "pound sign" and the "hash sign" (which American's call a "pound sign"!) are both Shift-3 on "101" k...