DSXchange

You can't really stop 'reading' at the first record delimiter. What I supposed the suggestion is would be to attempt to pull off the first 'record' in the Derivation after the entire file has been read in. May work... but I don't think that's the right choice of character to look for. Is this a UNIX...

Two problems - they want the duplicates and this is a Server discussion. I know you made the 'project architecture' comment, so perhaps only one problem then.

There is no dsenv file on a Windows server. That's a UNIX only concept, Windows controls all that via the registry.

I dont have any tool to run a query on You should have access to command line sqlplus at a minimum, unless you don't even have a logon to the server where the Oracle database is installed. If that's the case... jeez - it sucks to be you! Kind of hard to do your job without the tools you need to do ...

Probably best to contact whomever at IBM does Sales Support for your company, they should be happy to explain all that. I have no personal experience with those PACKS but have accessed PeopleSoft directly and know what a PITA that can be.

Let's start over, Narasimha was too subtle with his FAQ question. Post this in the proper forum so we know what version, O/S, etc you have. This is not the proper forum.

Then someone can attempt to answer your question more better. Don't forget the 'yada yada' part.

Okay... so... no TOAD, no DBA access or access to anyone (like a Modeler) that could fulfill a simple DDL request? Good luck. How about running a couple of queries and then posting the results? SELECT table_name, column_name, data_type, data_type_mod, data_type_owner, decode(data_type, 'CHAR', c...

DSguru2B wrote:Did you take a look at the after job subroutine "DSSendMail". You can send an attachment with that routine.

Specifically, check out the DSSendMailAttachmentTester routine in the Built-In\Utilities section. You are running a 7.5.x version of DataStage, are you not?

People still use Lotus Notes? Talk to a Notes developer or Admin, they should be able to tell you how to do it, I would think. Or see if they will allow Blat to be installed as long as Notes supports SMTP... it's been way too long since I was at a site with it that I don't recall, but I believe it d...

Re-read the answers you got. No-one said you 'needed' the PACKS, just that they makes it easier because they understand the underlying structures and simplify the extraction process. As noted, if you so desire you can directly connect to the underlying database of any application, including this one...

(copycat)

It seems that the only way I can attach a file to an email is using sequences. What makes you say that? Been doing it for years before there were Sequence jobs and the post I linked to explained how to do it. Sure, a Sequence job would make it 'easier' but certainly isn't required. Edit - Oh. Windo...

jdmiceli wrote:Once I get it all working, do you want me to post the results and how I resolved each issue? Would it be of any use to any other newbies like me for their issues?

You betcha!

Welcome! :D And the answer is sure - as long as you've done two things: 1) Installed the two versions to two separate locations. 2) Installed the Multi-Client Manager. The MCM is what allows you to switch as only one can be active at any given time. It handles the registry entry changes and even 'ad...

Check this post, see if it helps.