DSXchange

The issue is not how to do it in DataStage. The issue is what Excel expects. Control B is a keyboard shortcut for Bold in Excel. This has nothing to do with how BOLD is represented in a file. If you are using a TAB between fields then you are not creating an XLS file, but a text file. There is no wa...

David, I create xls file. I can easily use char(9) as tab delimiters (i.e. FIELD1:CHAR(9):FIELD2), but I do not know how I coud use Char(2) for "bold". Thanks, Leonid David Barham cc: 07/03/2003 12:44 AM Subject: RE: Edit characters Please respond to datastage-users OK, so what kind of a file are yo...

That means you have a problem with your database or a configuration problem with the listener on the Oracle server. You need to get the DBA of the Oracle database to sort it out. -----Original Message----- From: bdegreef@nextiraone.be [mailto:bdegreef@nextiraone.be] Sent: Thursday, 3 July 2003 10:38...

When I try to run a datastage job I receive this message.

Asset.S_CONTACT: -- ORACLE error-- ORA-12500: TNS:listener failed to start
a dedicated server process

Bert.

OK, so what kind of a file are you creating to be the Excel report? Are you trying to create the XLS file directly (youd be braver than me), or a CSV file (in which case, I dont think there is anything that can tell Excel about formatting), or perhaps an XML file (in which case you could do the form...

What you set using the Administrator client are default purge parameters for the project. These are used by any job for which specific log file purge parameters have not been set in Director. These default values are stored in a file called DSParams in the project directory. Any job for which specif...

Every job has its own log file. That log file has a row in it that contains the purge settings for that job. When a job is created, copied, or imported, the default settings maintained in DS Administrator is fetched and put into this purge settings row. In DS Director you can set a jobs auto-purge s...

Hi, May I know what should I do to make changes of Auto-purge (via DataStage Administration tool) takes effect? Do I need to re-import of all the ETL jobs under the project? Or I just need to re-start the ETL server? Please advise. Thanks! Regards, Yik Foong. >From : Software Engineer, APPLS SERVICE...

There are transforms or routines under the DSX which handle dates based on 1st January 1970. Check them out. You may need to convert the milliseconds as Wolfgang suggested but, yes, Oconv will work. -- __________________________________________________________ Sign-up for your own FREE Personalized ...

Thanks, wolfgang, what I was really concerning is leap year issue. Now I know Oconv() function will take care of it. xiong -----Original Message----- From: wolfgang.huerter@gerling.de [mailto:wolfgang.huerter@gerling.de] Sent: Wednesday, 02 July, 2003 20:30 To: datastage-users@oliver.com Subject: RE...

NO. All system variables are within-process. Search the archives for more detailed explanation. Possible alternate strategies are the named pipe capability of Sequential File stages, system semaphores, system locks and creating items in the file system or in the DataStage Engine database. ----- Orig...

Hi All,

I have two jobs A ans B in distinct projects. Is it possible to use the
@USERx ( x = 0,4) variable to implement a communication mechanism between these
jobs? How to do that ?

Thanks in advance

Hi, The DataStage version is 6.0 on UNIX platform.It is a server job copying from one folder stage to the other. With regards, Wilcy On Wed, 02 Jul 2003 Ray Wurlod wrote : >Need more information. >What version of DataStage? Windows or UNIX platform? What kind >of job design (server, job sequence or ...

This is a topic for an orphaned message.

I create a regular Excel report and send it as an attachment in email. Thanks, Leonid David Barham cc: 07/02/2003 01:17 AM Subject: RE: Edit characters Please respond to datastage-users Where are you sending your output? To use bold and underline, the output device/technology has to understand these...