DSXchange

The projects done, the users are happy, and the DW is ticking over nicely. Time to take that long break Ive been promising myself for ages. The list has proven to be a valuable resource; keep it going. Special thanks to Clif and the sites hosting the archives. Its been probably the best list Ive par...

or even UpCase(String[1,1]:DownCase(String[2,Len(String)-1]) if you want to make sure that ONLY the first character is in uppercase... Neil. ----- Original Message ----- From: "Ray Wurlod" To: Sent: Thursday, September 26, 2002 7:50 AM Subject: Re: Upper case just the first character of a string > I...

The people from Ascential who participate here really do care (I know them personally and will vouch for that). To some extent they are constrained (frustrated?) by the business and marketing imperatives imposed from "on high", as are we all. An "official" enhancement request, lodged through the sup...

Its a warning rather than an error, and indicates that the column metadata in your extraction stage (presumable an ODBC stage type) does not correspond with what is actually in the table. Import the table definition (Import > Table Definitions > ODBC - you can View Data during this process), then re...

Interesting suggestion, Ray. Ill see if I can put something together and I guess Ill have to look into the Universe BASIC debugger as well. Do people from Ascential actually read and care about what goes into the "Wish List" forum? I ask because the only time I ever see a reply there is when someone...

Hi Guys Im importing tables from a Sql 2000 database into DataStage version 5. For some or other reason only the first column of the table is imported. I also get an warning e.g. "Gave metadata mismatch, COLUMN.PRECISION expected=0 Actual = 10". This is the first time this has happened. The problem ...

Suspect its in the "too hard basket" right now. Have you considered writing some kind of specification for one; what it should do and, more importantly, how it should do it? For example, a batch is nothing more than a job control code generator. Ordinarily you dont elect to see the generated code (e...

Christian You cannot set a jobs parameters when it is running, they must be set first. Hence you need to create a heirachy in which the parent job extracts the parameter, sets it in the child job, then runs the child job. Regards Adam "Pelletier, Christian" on 26/09/2002 04:27:39 AM Please respond t...

Craig I care. If the DS people are out there, this product is well overdue for an industry standard IDE like JBuilder, Delphi, VB etc.......... Please consider Adam Craig_Hulett@rsausa.com on 26/09/2002 01:50:48 AM Please respond to datastage-users@oliver.com To: datastage-users@oliver.com cc: (bcc:...

If its only one word in the string, use the CAPITALS Transform or the function it invokes, namely Oconv(String, "MCT") (masked character title-case). If its more than one word, if you only want the first character of the entire string converted to upper case, you need substring techniques. For examp...

Hi!

Is it possible to dynamically set a job parameter using DSSetParam in a Job Control?

I am reading the content of an hash file, and I wish to use this value as a parameter for the current job.

Thank for your advices

Christian Pelletier
Sr. Engineer
Phone: 1-925-737-7058

Well, I guess no replies means either nobody knows or nobody cares. [sigh] Oh, well... Craig_Hulett@ rsausa.com To: cc: 09/20/2002 Subject: Any chance of a Batch Job debugger? 06:51 PM Please respond to datastage-use rs Does anyone know if one is planned as part of the next big (Version 6) release? ...

Hi Cindy, you can use the Derivation "FileName" for a outputfield in the XML-Stage. Cheers, Udo Cindy Gordon 25.09.02 13:00 Bitte antworten an datastage-users An: "datastage-users@oliver.com" Kopie: Thema: DataStage XML Hi Is it possible to output the xml file name from a folder stage to be stored i...

Hi, There is a built-in transform CAPITALS is available under Transform/Built-In/String that converts a string to word-initial capitals. Each word in the argument has its first character replaced with its uppercase equivalent. I belive this is quite easy and straight forward. regards, Binu --- Giova...

Ive got it!!! I will use Oconv function with MCT option. Thank you very much. Best regards Giovanni ----- Original Message ----- From: "Giovanni Boccia" To: Sent: Wednesday, September 25, 2002 1:00 PM Subject: Upper case just the first character of a string Hello there, Just an easy question, what I...