DSXchange

You need two output links (one can be rejects). Lets call them Link1 and Link2, where Link1 connects to the database. You can derive a column on Link2 with the expression Link1.DBMSCODE - note that it is obtained from the link that connects to the database, yet is used on the link that handles rows ...

Hi all, i need to handle the DBMS return code. I try to use the DBMSCODE link variable but it does not work fine. How can i capture it?? Thanks all Riccardo Tani Staff Consultant Direzione Industria e Servizi Datamat S.p.A., Enabling Your Future Rome, Italy phone: 0039 (0)6 50272702 e-mail: rtani@da...

Dear all I am using DataStage 4.2 and just commencing the ETL process. Are there any specific guidelines which i need to follow. Are there any dos/do nots in the process which i need to be aware off... any limitations etc???? My Extraction routines would extract about 100000 records per week from a ...

Hi! Just hoping that there are some QM users here who can help me on the following. I am trying to do a L0 Analysis on my SQL Svr DB thru ODBC connnection. All the fields in my table appear as BIT, LONG & SHORT data types. When I click RUN, I got the following error message: Error creating Domain ta...

Also, your OUTPATH has an implicit "/" and should be changed to: OUTPATH = PDLM:output >* * Get the platform running on > PLT.INT = SYSTEM(91) > BEGIN CASE > CASE PLT.INT = 0 >* * Unix > PLATFORM = UNIX > PDLM = /; * directory delimiter > CASE PLT.INT = 1 >* * Windows NT > PLATFORM = NT > PDLM = ; *...

Can anyone out there tell me what might cause a job which has been running fine on the scheduler to suddenly unschedule itself? This has happened to a handful of our jobs over the past couple months, and I cant identify common factors among the jobs which are dropping off of the scheduler. Any ideas...

Hi John, I have to use basic because of the very complicated logic in the program. There is no way to use GUI to do that. I already have it done. Thank you! Leonid "John Campbell" on 12/03/2001 03:41:46 AM Please respond to To: cc: Subject: RE: Write to sequential file Hi Leonid, Why are you populat...

Hi Leonid, Why are you populating the file using basic when DataStage is so good at doing it? It will outperform any routine you write! If you must use Basic, then bear in mind the following: Improper data type is usually issued when you are attempting to use a file variable, list variable or null (...

Hello John, Assuming you have DataStage v3.6.3 or later, the following will work efficiently: Create 2 Stage Variables, one called InternalDate, the other called ValidDate (declared in that order) The derivation for InternalDate should be: Iconv(SourceVar,DateMaskThatDescribesIt - e.g. DYMD[4,2,2]) ...

Hello! I would like to write a constraint which checks whether a date is a valid date field. How do I do this? The input field is a character field. If this field contains a valid date field, I should write the whole inputrecord to a table. If not, the input record should be ignored. The Oconv/Iconv...

You can also use DataStage Macro names in pound signs. E.g. #DSJobName# will put the job name in where that parameter has been used. For example, as part of a file name. For a list of the Macros, look under the sub menu called from the derivation box,. ----- Original Message ----- From: To: Sent: Th...

You cant rm and touch the file after you opened it. -----Original Message----- From: lfrumke@sears.com [mailto:lfrumke@sears.com] Sent: Friday, November 30, 2001 10:54 AM To: datastage-users@oliver.com Subject: Write to sequential file Hi all, I am writing a job in UniVerse Basic which creates a seq...

Not really sure whats going on, but wanted to point out that you need to be careful with the WEOFSEQ. You dont normally need to use it for a new file, the CLOSESEQ will create the EOF automatically. The WEOFSEQ *truncates* the file from point where you issue the command, if not handled correctly it ...

Hi all, I am writing a job in UniVerse Basic which creates a sequential file with fixed record length. While the job is running I can see records been created. But when it is completed, the output file is empty. If I put WEOFSEQ and CLOSESEQ statements, then the job abends and after reset there is a...

Hi there, if anyone has some time please could you try and resolve my query. Basically I have a job which takes a flat file, runs it through a transformer, then uploads it onto an Oracle 8.0.5 database. The data types range from decimal, varchar and date. When this is run, I get this error: ORA-0146...