DSXchange

Firstly why? Here you are trying to squeeze your input (10,4) to (8,2) which needs to be looked into. Also how does your input data looks, does it have any Null values?

Do you have sufficient priviledges to create a job? If that is not the issue try to cleanup the resources.

Rajesh, Kill command will not do any cleanup for you, It will just kill hte process and many a times a dangerous weapon to use. Assuming, you having issues with the Job locks then DataStage has the functionality apart from just clean-up resources to release those jobs. It is described in Administrat...

If you mean to drop the other two columns then simply delete those columns from the transformer output tab or even better method will be to use modify stage to drop the columns. I hope you are not asking this....

what does you logs in the director say? post them here...

First trim the data then use left() to truncate it. But as ray suggested, check what those characters are before even going with the above rule.

check string() and substring() functions.simple case will be string[6,4].

Most common reasons will be loosing the network during the load and the other might be someone else had tried to access the same table which can create lock on the table.

First check you APT_ORACLE_LOAD_OPTIONS environment variable. If still problem persists then discuss this with your DBA.

Need more information. what does the log suggest ? Also does the user have access to the table? Check any constraints on the table.

Could you post the complete constraint? It will be easy to debug if you can specifically tell which records are getting dropped.
Also is it a typo that your IsNotNull doesn't carry the link information.

It is always good practice to sort the data before performing any aggregation. In your case if you just want to count the records processed or filtered, I suggest you better look for the DSGetLinkInfo().

You might have to check two things. Check whether you are reading your column names as the first record in the first and the second will be any line terminators or carriage returns at the end of first record. For the first case you can go to the sequential file stage properties and make first line a...

Yes you can. As advised log on to the Datastage Administrator client and go to the license tab and update it with the new authorization details.

Yes you can. As advised log on to the Datastage Administrator client and go to the license tab and update it with the new authorization details.