DSXchange

Search the PX manual for weekday_from_date; with this numeric value you can create your own text weekday string.

mcs_ravishankar wrote:hi
dataset cannot be used as direct input source. you can call it in another job as a reference.

I think you might have meant to say something else. I use DataSets as direct input sources and lookup sources all the time and there is no such restriction.

...I'm not sure how you keep a CHAR field from padding with spaces, even by trying very hard. The only way I could think of was to change the pad char to something else, like 0x000 I've learned never to state absolutes here unless I have proof and recent test cases; and even then Ray will come alon...

I don't know where your issue is coming from. A char(10) field will always have exactly 10 characters, no more, no less. Take DataStage out of the equation for a minute and just use your PL/SQL. What results do you get for: Select LENGTH(Char10Column) from TestTable; Select count(*) ...

Sort unique, remove duplicate, or using a transform w/stage variable when writing the dataset would do it. Also, the warning means that you are only getting one value returned. If you don't care which value it is and don't wish to fix the bad design you could deprecate the warning to an informationa...

Balajisr - thanks, great suggestion. I used "GetEnvironment('APT_CONFIG_FILE') to get the actual runtime value. I'm still keeping the call with IBM/Ascential open as they either need to add this functionality or document that it cannot be used but this workaround is good for me.

Well, I got a reply from support but don't really know what to make of it: You cannot use environmental variable in your Transformer and there does not seems to be any workaround. You will have to use Stage Variables within the Transformers. Particularly the second sentence which makes absolutely no...

If you write Varchar(10) "Hello" to an Oracle CHAR(10) you are going to get "Hello " unless you try very hard not to. Can you do a SEQ(In.Col[9,1]) and output that to a peek stage? It should be 32 (ASCII Space).

In a transform stage you can use the derivation "In.DateColumn[4,3]" to get "sep" from "29-sep-07"

Please explain what you mean; do you want to know which "node" is fastest or if another node configuration is faster?

Bonds - a CHAR(1000) field will use up 1000 characters regardless of contents.

I'm a bit confused about what you are trying to do, is it

1. "Hello" stored as "Hello ", or
2. "Hello" stored as " Hello"?

Force compile the job.

Ray - it has already gone to support. I'm averaging about 4 days before they even call back at this site and am a bit stuck; so I thought I'd throw it out in this forum to see if anyone has encountered this already.

I tried both the GUI and manually entering it; both failed. Tried first with the actual environment variables and then with the $APT_CONFIG_FILE for the test case to submit to support. Basically one of the parameters (well, project-level environment variables) is a path which is prepended to a colum...

1. No, it is not possible
2. No.

This is similar to asking "Can I compile my COBOL code with the C++ compiler?"