DSXchange

The parameters will be passed to dsjob from shell script which is turn will execute the datastage job. Example:

dsjob -run -param value1="Test String one"

We get an invalid syntax error. So how do I pass strings containing spaces and special characters as run time parameters.

Hi, I have PX job that reads the DECIMAL(9,2) type data from a UDB table and write into a sequential file. Since the data type is DECIMAL(9,2) for one the column, the leading zeros were also written into sequential file. Example: Output data in Seq file: Column A 0000002.50 0000001.00 Expected outpu...

Hi, Can someone please tell me How to include header row while wiriting into a sequential flat file. Ex: The seq. file should be look like this EMPNO|EMPNAME|DEPT 123|JOHN XYZ|150 234|XYX ABC|201 I'm able to create and write data into seq. file, but the header is missing. Is there any option in &quo...

I have installed Datastage 7.0 on my personal laptop. I have been running server jobs without any problem. But all of sudden this problem was started. I had shutdown and restrted the system and also re-installed DS 7.0,but no use. I see 2 errors in event viewer: 1. Windows was unable to load the reg...

Hi, When I started my DSRPC service on my system (Windows XP Prof), getting error "DataStage error: Unable to bind socket to uvrpc port. WSA error: 10038." Now I can not connect to DS server and I can not work on datastage anymore. Can someone please suggest me How to get rid of this probl...

I have verified and dsprc daemon is running. I stopped and started all services in Control panel, but no use. As you suggested i'll try all combinations of logins. but my guess is there is something else, may be 1 or 2 files got deleted/corrupted. 2days back When I logged in as adminstrator, a messa...

Hi All, Recently I have installed DataStage 7.0 on my laptop (OS: Windows XP professional) and I have been running few jobs successfully. 2 days bcak I cleaned up some unwanted temp files and uninstalled Norton antivirus. Now the problem is started. DS Clients (designer) is unable connect to DS serv...