DSXchange

Xiong and I were having an offline discussion, but I think this warrants posting on the list. Following Xiongs query below, I did some testing to see the interaction between arraysize and rejects. This could get lengthy, so if it really isnt relevant to you, you might want to hit "delete" right abou...

HI PPL, Im trying to import metadata using the DB2 plug-in from an AS400 system and Im running into the following error message: "The limit that has been defined has been exceeded. Please redefine the search criteria." Has anyone seen this before? What limit are they referring to? Thanks, Thomas Nel...

And if you actually want to process the trailer record rather than ignore it (ours have control totals we need to verify), off the top of my head you can do a couple of different things: Use an aggregator stage with "Last" as the aggregation to get the last record out in a separate stream. The main ...

I recently encountered this in a situation where the text file was so huge that it was inconvenient to pre-process it with any script that stripped out the unwanted lines (four header lines and one trailer line). After a couple of experiments with scripts running awk, sed or ed to get rid of the unw...

Hi PPL, Lately Ive been encountering a lot of flat files that has a footer record at the end and Im looking for a best practice to deal with these situations. What methods do you guys use to deal with these situations? Thanks, Thomas Nel KnowledgeNet Phone: 966 1 402 3350 Fax: 966 1 403 7172 E-Mail:...

Only the obvious, that the error message is spurious (not to mention annoying and misleading). ----- Original Message ----- From: walter.crockett@ascentialsoftware.com Date: Fri, 21 Mar 2003 16:05:28 -0500 To: datastage-users@oliver.com Subject: failed to connect to host > On DataStage 6, and now on...

On DataStage 6, and now on DataStage 7, which I just installed, whenever I try to connect to DataStage Administrator for the first time (apparently after any reboot, but Im not sure), it takes about three minutes and then I get this message: Failed to connect to host: wb-crocket-pc, project: UV (The...

Thanks to all the genius for the help on this one...!

John

John DSD.RUN JobName -1/0 Param1="VALUE" If you need to put this in a job then it will look something like this: open "DS_JOBS" to DsJobs else stop SELECT DsJobs Loop while readnext id do cmd=DSD.RUN :id: -1/0 execute cmd repeat This will validate all your jobs. Thanks Kim. "johnshot@bellatlantic.ne...

John, I have a utility that will create hash files based on entries in the metadata library. Ill send it to you privately. Also, I shall get it posted on www.datastagexchange.com -Ken --- "johnshot@bellatlantic.net" wrote: > Hi all - we are doing an upgrade 4.0 to 6.0.0.21. > Does anyone have DSD.RU...

Hi all - we are doing an upgrade 4.0 to 6.0.0.21. Does anyone have DSD.RUN TCL code for validating all jobs (or even one) to assist in recreation of Hash files? Specifically does this option exist on 6.0? Thanks John -------------------------------------------------------------------- mail2web - Che...

I got the messages below when attempting DS6.0 on AIX. Warning: command UVwrite VOC DS_LICENSE F DS_LICENSE D_DS_LICENSE returned (1) Warning: command UVwrite VOC DS_LICENSE F DS_LICENSE D_DS_LICENSE returned (1) Warning: command uvsh LONGNAMES ON NEWACC returned (1). Warning: command UVwrite VOC DS...

Hi there, Im trying to upgrade my DataStage server on IBM AIX 4.3.3 from rel 5.2.1 to 6.0r1. During the upgrade (during the project configuration) Im reciving the following errors: Command uvsh LONGNAMES ON NEWACC returned (255). Command uvsh UPDATE.ACCOUNT returned (255). Going on, the upgrade fini...

Hi, We are looking at changing the character set of our database ( datawarehouse) from US7ASCII to UTF8 to accomodate Thai character data. I need to know what are all the considerations/changes that are need to be done on the datastage side to make it compatible. If any one of you had gone through t...

All, I am preparing to look at the method that we are using to run a set of DataStage server jobs. One of our options is to lightly wrap the Job Sequencers with some custom code to pass parameters on the dsjob command line. Are there any issues with the Job Sequencer that I need to be aware of? I kn...