DSXchange

I would need to look around as well. Perhaps start with "netstat -a | grep ds" to see if anything suspicious shows up. Are you using "dsadm" or "dsrun" or some similar userid and does "ps -ef | grep {userid}" show any pids?

Sequential files are split into "records" by using <cr><lf> (windows) or just <lf> (UNIX). By manually adding these characters to a string, you create new records. So in your case if there are 3 columns to split, you would read one record, add char(10) three times and do one write. But whe...

I was referring to the "StartServer" command, I missed that in your original post.

I guess it boils down to the

Caused by: java.net.BindException: Address already in use (errno:226)

line in the log. Could it be that there are still processes out there that might be blocking that socket?

You can get the appropriate PID by using either the graphical Director list or by executing "PORT.STATUS" from the command line. But I still go back to my original statement of activating the deadlock daemon - that will take care of finding the correct process(es) to get rid of and all the...

You can create the file in &PH& or create your own type 19 file, compile it with "BASIC &PH& MyProgram". I'm not at a DS site right now, but it might be that the debugger was removed from the original UniVerse when DataStage was split out. What kind of error are you getting...

What did you specify in your stage as "transaction size"?

Manuel, I found that messages get written to all sorts of files at V8 and the message that one is looking for is seldom in the file where you might expect it. What I did was to get rid of all log files before a restart and, after the error occurs, to search them all for error messages. Can you start...

The RAID debugger is the only debugging tool out there for BASIC programs, there is no graphical tool available. With some large job control programs I found it easier to save it into a file and compile/debug it straight from the command line as you can add and remove comments and debug checkpoints ...

Never EVER do an UNLOCK ALL in UniVerse unless you know exactly what you are doing. This removes all levels of locks from the whole system and can mess up many things, particularly with many running jobs or when many developers are working concurrently.

What character set is your target table defined in? You will need to check each character, find the corresponding character in ISO8859-1 and see if it can be represented in your target character set.

In a transform stage make a output column derived from In.Col[1,5]:Char(10):In.Col[6,5]:Char(10):In.Col[11,5] and so on. This adds a <LF> to the output string and when that file is read again it will read in one value per row.

What about using the suggestion I made, using positional contents to decide how to parse the dates?

After displaying 60% the process just hangs forever? Can you monitor system performance from UNIX (I like "vmstat") to see if the machine is still busy?

You can access the log messages by using DSGetLogInfo(), then those values can be written to Oracle using the normal processing stages in a job.

Using search you could have found viewtopic.php?t=115038&highlight=code+141