DSXchange

Hello there,

Just an easy question,

what Ive to do is to convert in Upper case just the first character of a string. There is a function to do that??

Cause Ive checked that the UpCase function reply me all the character in upper case.

Thank you very much.


Giovanni Boccia

Hi Is it possible to output the xml file name from a folder stage to be stored in a table. Thanks Cindy ________________________________________________________________________ This e-mail message (including any attachment) is intended only for the personal use of the recipient(s) named above. This ...

) Please forget the previous emails...They are the same. Tks Christian > -----Original Message----- > From: Pelletier, Christian > Sent: Tuesday, September 24, 2002 4:31 PM > To: datastage-users@oliver.com > Subject: Exec Vs Call - Sorry for the previous mail... > > Hit the wrong button... > > ) > >...

Hit the wrong button... ) So DataStage is generating a Call statement when I use a stored procedure in a ODBC stage, as in this example: {call Jamba_che.dbo.p_WrapStoredProc(p_GetNextId, 10, 1)}; But for some unknow reasons (at least to me...), the result I get is different wheter I use Call or Exec...

Hi All!

Can someone explain to me the difference between Call and Exec in SQL Server?

DataStage is using call when I


Christian Pelletier
Sr. Engineer
Phone: 1-925-737-7058

There is very little detailed information in the public domain about wave number. It is an internal mechanism that DataStage uses to keep track of how much information to preserve should a job not complete successfully; a new wave number may be allocated to allow a new "instance" of the job without ...

Can I do this safely without touching other processes? -----Original Message----- From: Glenn Herbert [mailto:glenn.herbert@ascentialsoftware.com] Sent: Tuesday, September 24, 2002 10:12 AM To: datastage-users@oliver.com Subject: Re: Unknown process using PORT.STATUS If you login as an administrator...

Hello everyone,
Could someone give us detailed information about the DSJobWaveNo macro...we think we might be able to use it to generate job batch numbers...thanks, Regards, Doris and Mike

Unfortunately, it sounds like those file entries have an OS lock on them which can only be released by a system reboot. When a DS job is run, the OS puts a lock on the files being used to manage contention (you can see this if you use Exploder - er, explorer, while the file is in use and you get a n...

This may not answer your question directly, but I do have a suggestion. Do not use "kill -9 pid" to remove the processes. The "-9" option is a kill immediate option that does not allow a process any cleanup. First try "kill pid" and if that fails use the "-9" option. -Doug -----Original Message-----...

Hi Glenn, We have the same issue within DS 5.2r1 on Windows 2000. I.e., many entries in the &PH& file which we cannot delete, clear, or logout. Ive used DS.TOOLS and run the options to release locks, logout processes, etc. And, like Myles, I do not want to have to recycle DataStage to clear out thes...

If you login as an administrator (dsadm or root) to the DSEngine account (UV), then at the command prompt ( > ), enter the following: RUN ADMIN_BP REMOVE.SHM This will remove those unused/abandoned shared memory segments. Hope this helps. Glenn At 09:38 AM 09/24/2002, you wrote: >When I use the PORT...

When I use the PORT.STATUS command I sometimes get a couple of unknown processes. This usually occurs when a user has a connection problem and we have to go in and unlock the user using UNLOCK user.no ALL, and then killing the UNIX pid(s) with "kill -9 pid". Ive tried using LOGOUT -pid but the pid c...

Hi Peter, the question was an other question than your one. But nevertheless, that is not important. You want to have an answer to your question. There are functions within DataStage to read your Logfile and even to write additional lines to your logfile. One of many ways is to write an after-job-ro...

DataStagers The UNIX split command wil split one file into many based on blocks or lines. You can split them into 10,000 lines each or wharever. It will take named xxx and split it into xxxaa, xxxab, xxxac and so on. You could then use then the cat command to add your header files. If you need a she...