DSXchange

I'm currently running on Windows and I'm trying to find a nice way of reading a sequential file starting at the nth last line. Something similar to the UNIX tail command but in a routine. I know you can use seek to go to the end of the file but once you've done that all I can think of is seeking bac...

Is this due to network traffic by any chance?? B'cause sometimes it's working fine and if more than 5 developers trying to access it, it is throwing the 8102 error.

The user limit says 5.

Sounds very coincidental all the same!

Back to the original question. I guess the most, if not only, elegant way is to use something like ComBridge http://www.octatec.co.uk/CB_sum.htm which allows you to access COM objects on Windows. This assumes that you have a COM object to run or can write one. Your original problem stated I'm lookin...

There was a recent discussion about a similar problem.

If all your files look OK and the job used to run OK, check if the job has active stages in sequence and, if so, try placing an IPC between them.

My guess is this is a licensing error. I know you get an error when you hit the limit but I can't remember the error number. Easy way to check - next time you hit the error, ask someone to log out and try logging in.

Can some please tell me if there is any impact to the job or long term advantage in defining data types when importing table definitions from a sequential file? As far as I can tell, there seems to be absolutely no impact on the job. In fact even the length seems to make no difference (at least in a...

Have you checked out your user limit in DataStage Administrator?

You never answered my previous questions.

Also check this out.

http://www.dsxchange.com/viewtopic.php ... uid+or+gid

Is it possible to use rsh to a Windows box?

I wasn't aware that you had those sort of services on Windows. You can certainly run rsh from Windows to Unix but I'm not so sure about the other way around unless you have SFU installed.

You also need to wrap the 080012 in quotes

i.e.

'080012'

Ray,

Should the MKS toolkit be automatically installed with the DataStage server?

I'm running 7.5.1 on Windows and I can't seem to find an MKS directory.

add a semi-colon to the query.

Does this only happen after your session has been idle for a while?

Does it happen only to DataStage clients or do Telnet sessions also get timed out?

Have you checked the process start times of the dsrpcd daemon to eliminate the possibility Ray mentioned?

Just out of curiosity I decided to do a small test. First with SQL declare cursor c1 is select object_name, case owner when 'PUBLIC' then 'P' when 'SCOTT' then 'S' end from sys.dba_objects; begin for c1rec in c1 loop null; end loop; end; / PL/SQL procedure successfully completed. Elapsed: 00:00:00.0...

Sounds like you're going to have to manually assemble the fields into a generic type record. i.e. Write a routine that will take the complete input line as a parameter. This routine will examine the line, determine the value of the IDColumn and then assemble the required output in CSV format. L1 L2 ...