DSXchange

LEAVE IT BLANK AND TEST -----Original Message----- From: m_musumeci@inwind.it [mailto:m_musumeci@inwind.it] Sent: Friday, May 31, 2002 9:29 AM To: datastage-users@oliver.com Subject: NULL Value in Test Routine Hello, In the Test Routine dialog box I would like to set the argument Arg1 to the @NULL v...

Hello, In the Test Routine dialog box I would like to set the argument Arg1 to the @NULL value to run a test with this value. If I set: Arg1 = @NULL the Test Routine dialog box set Arg1 to character string @NULL ! Did you Know how I can do this ? Thank you for interest. Massimiliano

hi charles, in director, when you select JOB then Clear Log you can set it up so the log file is cleared prior to each run or after x number of days or whatever. try that. -----Original Message----- From: Ghobrial, Charles [mailto:CGhobrial@nvrinc.com] Sent: Thursday, May 30, 2002 3:16 PM To: datast...

I am not positive, but doesnt the pivot stage do this. I have played around with it a bit and if I recall right you can do this in the pivot. -----Original Message----- From: Rachel Pedreschi [mailto:RPedreschi@vailresorts.com] Sent: Thursday, May 30, 2002 2:10 PM To: datastage-users@oliver.com Subj...

And I was never in Vail, honest!

--
Regards,

Clif


Thursday, May 30, 2002, 2:49:19 PM, Galemmo,Nicholas,GLENDALE,IS wrote:

> Besides, how is anyone going to believe your example? Rooms in Vail
> in February for $100 a night? Really???

Hi Charles, To Clear the files in Director, go to Job on the menu bar and clear log. You can also set Administrator up so that log files at certain times. I hope this helps! Regards, Damien Kavney -----Original Message----- From: Ghobrial, Charles [mailto:CGhobrial@nvrinc.com] Sent: Friday, 31 May 2...

Wow! This looks like it will do the trick! Thanks so much for your help... let me know if you need a ski pass or two. -Rachel >>> kcbland_2000@yahoo.com 05/30/02 04:22PM >>> Rachel, this logic should do what you want: Put this into a DataStage function with (1) argument. In this example, I used your...

Well, it could always be Keystone... >>> nicholas.galemmo@us.nestle.com 05/30/02 03:49PM >>> I think the Pivot stage does the opposite... takes n records and creates 1 record. You could write a procedure to write the data to a new file with the multiple rows and then process the file. Besides, how i...

Rachel, this logic should do what you want: Put this into a DataStage function with (1) argument. In this example, I used your test string as a test value to Arg1: "Oliver, 2/1/2002, 2/1/2002, 2/4/2002,3, $300". I cleaned up the data whilst in the logic so that things looked prettier. I did this by ...

Rachel, I posted this back in April but will repost here the same text. It describes the most simplest and scalable solution for you: Your problem is one source row creates an indeterminate number of output rows. If you write a function that accepts as the only argument the entire row of data, that ...

I think the Pivot stage does the opposite... takes n records and creates 1 record. You could write a procedure to write the data to a new file with the multiple rows and then process the file. Besides, how is anyone going to believe your example? Rooms in Vail in February for $100 a night? Really???...

Hello, I am a new Data Stage 5.2 user and I am trying to convert a single record into x records. Looking through the archives, I saw some information on doing this with the Pivot Stage, but I cant see how its going to work. The situation is that I am trying to convert a hotel Check-out record into i...

Charles, are you refering to job logs in Director? I dont think you could possibly have a 10 Gigabyte log file in DataStage. Clearing it is an easy as using Directo Can you be a little more specific? Thanks -Ken --- "Ghobrial, Charles" wrote: > Hi all, > > Is it anyway I can empty log files in datas...

hi everyone, We have a workstation with DataStage 4.0.3 client installed. Its running Windows NT 4.0 with plenty of ram and disk space. We see all the objects in the Designer window but when we open a transformer stage the tables and links dont show. What we have is an empty window. Does anyone have...

Hi all, Is it anyway I can empty log files in datastage 5.1. I cant copy all jobs because logs exceeding 10 G. Thanks, Charles Ghobrial Data Warehouse Architect TEL: 703-761-2021 FAX: 703-761-2191 ---------------------------------------------------------------------------- ------------- 7601 Lewinsv...