DSXchange

2. How do we read this into another file with only 3 cols as different rows. The job looks like this: SEQ#1 --> XFM#1 w/routine --> SEQ#2 --> XFM#2 --> whatever The metadata in SEQ#1 is a single column. The XFM calls the routine, passing it the entire row which is just defined as a single column. S...

Ray, Kim, and Arnd are probably the only 3 people on this forum who would know how to write a purely DS BASIC solution that would work. I doubt anyone else (and I include myself) could successfully do what is being requested. We don't know what the "batch process" is that is writing to this sequenti...

Kirtikumar wrote:Lets see if it works or not.

Not. I'll bet a box of donuts on it. I like Dunkin Donuts chocolate. Mmmm.. chocolate.

A batch process is accessing this file to append data processed. At the same time, another DS job should access it and delete the matching line. This will never work. Files used buffered i/o when writing. There's no guarantee that a complete line will be in the file, because there's no concept of l...

Is this a new installation or an existing one? Has this worked before or do we need to walk you thru configuring PX for Oracle?

When you go thru the installation, you are asked where to install the DS Engine. That is in essence the path to the repository of the core tool. You create projects within the tool to hold job design information. Again, when you create the projects, you supply the path where you want the project to ...

Next time do exports by category/folder. You want individual files at least at the folder level, so that you can more easily import specific jobs.

Or look at this post to get a copy of a perl script that explodes a single large dsx file into individual files for each job and each routine.


http://www.dsxchange.com/viewtopic.php? ... teve+boyce

How do I view the repository? What do you mean, view? Use the Manager to "manage" jobs, routines, metadata. Use the Director to run and visit the job logs. Use the Designer to write jobs. I know you're new, but are you that new? Have you ever seen the tool? If not, please visit www.ascential.com an...

How soon is now? Repository is mostly server side. There's a few nasty things that are stored client side, like templates. But, job designs, logs, routines, etc are all server side. Since you posted in Server Edition forum, there's no need to cover MetaStage. Unless you've somehow have in your posse...

Jeez, gave up on the easiest solution awhile back. A single click for Pete's sake. Instead, we're now in the realm of prepping the file. Rather than use the unix program design for stripping ^M from a file, we're talking about the finer points of how to use sed. Why not ftp the file to a Windoze mac...

Have you read the PX developers guide section on the Switch stage, with its example? If not, you should start there if you persist in your design strategy. You will have to go into detail as to how you configured the Select column and the conditions for the output links if you need more help than "i...

How did you expect to feed the result from a stage to a before/after routine? I'm not aware of how you can do that. Filenames are fixed when the job begins, therefore, any parameter or macro is ran when the job/link begins. Your after-job routine can be ExecSH and run a shell command (perl/java/ksh/...

shivaprasad wrote:Urgent means i need it badly sir,
hope you help me, i have monday a delivery for this.
So pls help me.
Thanks

So, did you get it working?????

Why use sed when dos2unix does the trick without fuss?

http://linuxcommand.org/man_pages/dos2unix1.html

Here's a quite answer. The normalize functionality is for using the stage with hash files created using the multi-value capabilities residual in the product engine from its parent version, Universe. In Universe, of which the DS Engine is a variant, there is the capability to store something called m...