DSXchange

Hi Ian, it is general what Riccardo proposes: dsjob Command Syntax: dsjob [-file | [-server ][-user ][-password ]] [] use it the way above. Wolfgang > -----Original Message----- > From: Ian Godsell [mailto:Ian.Godsell@three.co.uk] > Sent: Wednesday, January 29, 2003 1:03 PM > To: datastage-users@oli...

Hi There, Ive got a really simple questions for you. 1- Ive to check if a string contain a particular character. 2- Ive also to check if a string contain more than 2 equal character (BBB, CCC, DDD........). The question is really easy, and i know that there is many way to resolve it, but the problem...

Hi Riccardo, I do not seem to have these options available to me. What version of DataStage are you using ? $ /opt/ascential/datastage/DataStage/DSEngine/bin/dsjob -logsum Invalid arguments: dsjob -logsum [-type ] [-max ] Status code = -9999 $ Regards, Ian. -----Original Message----- From: Riccardo ...

Hi Ian, try also to add the options -server -user -password (see "Server Job Developers Guide") Hope this will help you Riccardo ----- Original Message ----- From: "Ian Godsell" To: Sent: Wednesday, January 29, 2003 12:21 PM Subject: DataStage / Unix problem. > Hi All, > > I am having a Unix / Datas...

Hi All, I am having a Unix / Datastage issue which I cannot resolve. The error along with the command is listed below. /opt/ascential/datastage/DataStage/DSEngine/bin/dsjob -logsum ADMv02_3 STGLoadCCVParty ERROR: Failed to open project Status code = 80011 Note: When executing this from the Unix prom...

Dinesh, You are not alone. Datastage has had this problem since about 1996. I have reported it to them many times and it has never been fixed. It is nothing to do with your platform. I have used datastage on Unix and NT and its the same on both. There has never been a version where it has been fixed...

DataStage Users: We think we have a program that every DataStage site needs. Most sites are running jobs 24 hours a day 7 days a week. We think you should be able to monitor those jobs safely and securely over the web without changing your firewall. DsWebMon will allow you to do that now. You can do...

This is a topic for an orphaned message.

Are you using the Date data element? In the ODBC stage (and Informix CLI is built over ODBC) the use of the Date data element will cause the date read from the database table automatically to be converted to DataStage internal format (which is the integer number of days since 31 Dec 1967). I suspect...

Mark It depends on your metadata for this field. The internal form of a DataStage date is an integer. Tell DataStage this field is a varchar and see what it looks like. Thanks Kim. Kim Duke DsWebMon - Control DataStage from the web www.duke-consulting.com -----Original Message----- From: Mark Ewart-...

This is a topic for an orphaned message.

Everyone, I am using DataStage 5.2 on HP-UX platform. I am getting a strange problem during job development process using Sybase OCI Stage. In my job I have Sybase OCI stage with multiple outputs to different files. First time, I can define the SQL for each output link and save them. Next time onwar...

-----Original Message----- From: ccezon@bancozaragozano.es [mailto:ccezon@bancozaragozano.es] Sent: Tuesday, January 28, 2003 7:23 AM To: datastage-users@oliver.com Subject: RE: Sequential file Hi Ricardo, I have tried it but it doesnt work. I need to treat LF as line terminator, no as part of data....

Hi Guys Im extracting a date from an Informix database. The date has been defined as dmy4 in Informix. When DataStage 6.0r3 reads the table in question I get an integer instead of the date. Is there something I need to set to be able to see the date correctly? I have done an Oconv on the date and I ...

Yes. > -----Mensaje original----- > De: Jason Gibson [SMTP:JasonGibson@three.co.uk] > Enviado el: martes 28 de enero de 2003 12:39 > Para: datastage-users@oliver.com > Asunto: RE: Sequential file > > Have you set the line termination to Unix (LF) in the sequential file > stage > > > -----Original Me...