DSXchange

Yes, that is what I am doing. Happy New Year. Thanks.

OK, when I tested with 2 SQLs, I defined 2 O/P Columns, but should have been one column only as my SELECT query returns only one column but 2 rows. So, that is resolved now. But still, for mixed no of result sets (multiple SQLs), I need to figure out a design.

Thanks Craig. When I tried 2 SQLs with union (same no and type), following error appears. 'DB2_UDB_API_29: The 2 column(s) defined on this link do not match the 2 column result set generated by the SQL statement:.....".

Thanks. UNION does not work even in TOAD, as the return values from the SQLs are different numbers (One SQL returns 2 fields, another 5 fields so on). Multiple source stages is an option but since there are many SQLs, I am keeping that as a last option. Not sure if I go for 'Load SQL from File at Ru...

Hi, I am trying to read from a few DB2 tables by running different (stand-alone) SQLs and send it to a file. In the DB2_UDB_API stage, I am using 'Custom SQL statement' and it appears that only one SQL can be entered here. Please let me know if there is a different approach to achieve this. Thanks i...

Thank you again,

We have DS jobs that will run soon after source batch complete. I am trying to understand how to accomplish this using autosys.

We don't have autosys on DS server or DS client on Autosys server, and they don't want to install one.

I am trying to understand what is the go around.

Will this client on the DS server be controlled with other auto sys clients in other server?

Hello every one, Not to hi-zag the thread, but a similar question. I have DS installed on one server and Auto sys on a different server. Do we need to install client(both Autosys or ds client) on either of the servers for DSJOB command to work? My actual question is how would autosys batch script lo...

ray.wurlod wrote:The next thing to check is the firewall. Is port number 31538 open? This is the one needed for dsrpcd - the one on which it listens for inbound connection requests.

Ray,
We checked port 31538; and is open.

Thank you Ray, All the engine folders and project folders are having full access to admins. DSRPC service is up and running. User id's are local and has admin roles. selection of Omit check box gives 'host not responding 81011' error. Not sure if there was any security patch applied to the windows ...

You also need to check permissions on the engine directories and all their parent and sub-directories. And even then the issue may not be one of permissions. Is the DataStage RPC daemon (service) running? Are you using local user IDs, or domain or LDAP based user IDs? Can you connect with the Omit ...

The 39xxx error codes are platform-independent. Ray, If these errors are platform-independent, and looking at some of the UNIX platform solutions in other forums, what is that we have to change in the project directory access in windows envi? Project directory has full access to every one; even adm...

Search is your friend as most questions have been asked before. :wink: For example, this thread, while covering other topics should also provide some help for your error message. There were others, so if this fails to help try searching for "39202" again... and if after that you're still ...

Thank you Chulett...

Thanks Chullet.. Yes we should specify full path of the target sequential file. I just wanted to know if by mistake, we specify only the file name, in which location datastage creates that file? Is it like C:\IBM\informationserver\project\ <projectname>.....! Can you mention the exact location of th...