DSXchange

prabu

ArndW wrote:UniVerse is one of those older products that was initially designed with uppercase only. You can switch around the case changing using the command "PTERM CASE NOINVERT" and turn it back on with "PTERM ...

Eureka! it works great

Code: Select all

HELP PTERM

gave me all

thanks ArndW and Ray!

prabu

Hi Datastage folks, hope you all do great! whenever i try to copy paste some commands in Universe it is auto-converting it to the opposite case. [lower to upper and vice-versa]. any reasons for this strange behaviour. i manually change the case to lower and then paste it. it is painful . questions a...

prabu

The number of arguments in any DataStage Server Routine (the kind you call from a Routine activity in a job sequence) is fixed, not variable. There ought to be no need to interrogate the number. I ... makes sense. just to confirm, the argument type in a routine should always be a scalarit cannot ta...

prabu

Prabu, Can you please tell us your understanding of ' Null ' because if you just set the property in sequential file as Null Field value ='' it will be similar to Null in Oracle. --dsusr Hi dsuser, my target is not Oracle but a sequential file and i want to set the value to "Null" , same ...

prabu

Prabu - I hope the column is nullable - yes. Since the the error is at export, for test, try with a sequential file to a dataset. Hi Kumar, Yes, the column is nullable. I miss the point here, why a dataset as target :roll: . my target is a sequentia file and it expects the null to be handled as a p...

prabu

kduke wrote:If you type HELP SQL then you can see some of what is supported.

it's really, really helpful, thanks Kim and Ray

prabu

Hello Folks,
could you please share your expertise on the following:-

1) is there any special variables like $#(in UNIX) to find out the argument count in a routine.

please let me know!

regards,
Pabu

prabu

Prabu - What if you dont use any of these properties. Null should be transfered as Null. Are you getting the same issue as Cetin getting? it's not allowing me to load the seq file, if the field value is null and the null value property is not set. Meaning, these null records are rejected. i assume ...

prabu

Hi Kumar, I agree with you. Nulls should be tansferred as nulls if you don't do anything. I solved the problem using unknown data type in the right side of the mapping of the transformer. I have to use transformer anyway, because of other fields ransformation. Cetin, my question is,if its a straigh...

prabu

ray.wurlod wrote:Some interesting concepts here for a Time dimension. ...

some more dimensions

prabu

well said!

prabu

any volunteers???

prabu

Hello moderators, Any plans to launch a forum like this http://saloon.javaranch.com/cgi-bin/ubb/ultimatebb.cgi?ubb=forum&f=32 concept: If I felt like talking about something other than Datastage with a bunch of geeks, I could have a place to do that. Posting in this forum, so that folks can have...

prabu

thanks ArndW and Craig! it's good to get clarified on this.

prabu

adams06 wrote:Hi,

How to convert multiple rows of data into single row?

ex: input

field1

a
b
c
d

output:

a,b,c,d

1)pivot stage

DSXchange

Search found 142 matches

Universe command line -case change..

null , null who holds the key to null!

Argument count in a routine like $# or $@ in UNIX..

some more dimensions

any volunteers to exlain @NULL and null value expression

Any plans -> DataStage meaningless drivel

Re: How to convert multiple rows of data into single row