DSXchange

Look at using remsh or rsh to run remote commands on foreign servers. Better yet, why not just have a process running on that foreign server to monitor local files and once IT sees the trailer record it either creates a "ready" companion file or moves the file into a different area?

Search the forum, there's a method recently discussed to select from the DS_JOBS hash file to get a job's internal storage number. That number is used in the naming convention for the supporting hash files of a job design (RT_LOGnnnn being the one in which you're interested).

no

Well, how good are you at DOS .bat file writing? If you're limited to Windoze, you've only that scripting language, unless the server has perl or java. Performance might be an issue with DOS scripting.

Write a C/java/perl program/script to return TRUE/FALSE if the last line is your trailer record. Execute it remotely and act accordingly.

Your problem is that the file on the FTP server isn't complete until it has a text string at the bottom of the file. At that time you wish to fetch it from the site. Given that there are limited Windoze commands for doing what is equivalent to a Unix tail command, can you tell us what options you do...

Search the forum for the numerous examples of using stage variables on sorted data to assign the ranking number. It's very easy, you'll need the data sorted in the desired order and then setup 3 stage variables to do the work.

Yes it's safe. Change every job that uses a Sequential stage to have the correct slashes and file types for unix. Change all ExecSH calls to have the appropriate slashes as well. Change all DSExecute calls to have the Unix platform option, as well as any slashes. Update any BASIC functions, routines...

The ORAOCI stage adds a To_DATE() to all columns where the datatype is DATE when using generated SQL. You need to make sure your datatypes say DATE and get all your dates into YYYY-MM-DD HH24:MI:SS format, or atleast YYYY-MM-DD in order to take advantage of generated SQL. If you wrote user-sql, it's...

That's correct, left to right when you don't have these ( guys ).

And also don't post the same question in multiple forums.!!!

Because of the rigid metadata paradigm of sequential file stages, we've all been impacted by the poor implementation of delimited files with embedded delimiters in poorly quoted data files. When both DS Server and PX encounter these files, they parse them poorly, but how can anyone blame them? You c...

There are no datatypes in DS Server. You need to write a function to subtract dates. Better yet, have one that understands dates and time. Here's one I posted a long time ago:

http://www.dsxchange.com/viewtopic.php?t=85788

Create a function and paste this logic into it, it will do what you need most of the way. Have fun.

No. You can, however, use a Batch job to execute a system level command to get the list of files to process, and then, in a loop using the DS job control API's, start the job(s) necessary to process each file, passing the filename as either a parameter or moving the file into position for processing...

ping alpha.iml.com from your PC to make sure alpha.iml.com is in your hosts.ini file. If that isn't getting thru, you need to get that DNS into your hosts.ini file after obtaining the IP address.