DSXchange

What version of DS contains the updated XML stages? Javi ernie.ostic@ascentialsoftware.com on 12/02/2003 23:21:32 Please respond to datastage-users@oliver.com To: datastage-users@oliver.com cc: (bcc: Javier J Perez/cp1/qdot/au) Subject: RE: How to process a XML input file with missing tags ? *******...

Thanks for your contribution, Wolfgang. My contribution was a solution, not a problem. It uses DSSetUserStatus() in a column derivation, so that subsequent jobs can retrieve its value, perhaps as you can describe, perhaps via a DataStage macro or DSGetJobInfo() in a Transformer stage. Its ultimately...

Hi Ray, I dont realy yet understand your Problem, so I write something about the function you use, where I am assuming, that you know this details already. Let us assume you have a Job1 and a Job2. In Job1 you have anywhere the function DSSetUserStatus("It is a nice day") When you have in Job2 for e...

I undertook to advise of a generic way to set the user status value within a job, based on a recent project. In this example the job design is: ODBC ----> Transformer ----> SeqFile The ODBC stage executes a stored procedure (in SQL Server as it happens) that inserts a new row in a table, generating ...

MONTHLY POSTING - DataStage Users List As of 11 February 2003 the DataStage Users discussion list had 742 subscriber addresses. A few of the addresses are to organizations who then redistribute the postings to more than one reader. ================== Posting Guidelines ================== 1) Non-mode...

Does anyone know if DataStage v6.0 supports Unicode? I noticed that v6.0 has "NLS Enabling" as an option, but did not know if that included Unicode. I would assume that NLS enabling would allow for sourcing data in Chinese, Korean and Japanese (Using Unicode standards), but I just wanted to verify. ...

You could set the timestamp parameter via a DataStage Basic Controller Routine which executes the appropriate Job(s). Or immediately after performing the FTP stage you could execute a UNIX command, I assume that this is a UNIX system you are working on, to set the date as you want. As an example: mv...

That is how I would like the job to work. Im finding out if the script that runs it can obtain the timestamp to pass into the job. Is there a way to set the default value of a timestamp paramter to a timestamp in job properties? It didnt seem that you could use DS macros such as DSJobStartTimestamp ...

How about using a Job Parameter for the timestamp as well? Then in the FTP stage, your filename could be "#filename#.#timestamp#" or something similar. -craig jash7@sears.com 02/11/2003 09:07 AM Please respond to datastage-users To: datastage-users@oliver.com cc: Subject: Need to append TimeStamp to...

Jenny Is the timestamp to be from the source system or destination or can you be guaranteed they will always be the same? Is the timestamp to be when the ftp begins or when its complete? "Today is another day to reinvent the future", Donald Shearer 1975 Research Parkway, Suite 120 Colorado Springs, ...

I am using the FTP stage in a job. I have one file I spilt into 4 and FTP these 4 files to a remote server. I need to append a timestamp at the end of each file name like this: filename.timestamp. I am using job Parameters for the filenames. Any suggestion how I add the timestamp? Thank you! Jenny A...

I would like to thank Giovanni Boccia, Riccardo Tani and David Bahram. I Followed your advices but the problem was a corrupted file called rundll32.exe. I hope that my experience coul help everyone in the future Pasquale, Angelo Vaira Cap Gemini Ernst & Young Italia S.p.A. Via di Torre Spaccata, 140...

Thank you Wolfgang. Leonid wolfgang.huerter@ gerling.de To: datastage-users@oliver.com cc: 02/10/2003 08:29 Subject: RE: Status 21 AM Please respond to datastage-users Hi Leonid, You can find the status-numbers in the JOBCONTROL.H: Here the extract. Possible return values for token DSJ.STATUS: Equ D...

Hi Leonid, You can find the status-numbers in the JOBCONTROL.H: Here the extract. Possible return values for token DSJ.STATUS: Equ DSJS.RUNNING To 0 ;* This is the only status that means the job is actually running Equ DSJS.RUNOK To 1 ;* Job finished a normal run with no warnings Equ DSJS.RUNWARN To...

Hi all,

Does anybody know what does the job status 21 mean?
Here is the message in the job:

Event type: Other=0

NonResponder: Synchronization error Resource = DSD.Notify, CurWave =
NonResponder, LastWave = 352, Expected 352

Thank you,
Leonid