DSXchange

What is the length and datatype of DESC?
If it is not char from database, and if you pad some char in Datastage, you cannot check for single character.

Difference between Ferrari to Ford... Almost all the work done by Datastage can be Perl scripts. SAS and Datastage are both different product involved in building Data Warehousing. Datastage is one of the superior ETL tool. SAS is one of the product which gives end to end solution. It has many produ...

I dont think PX to do with this topic to be resolved. Webmaster should look into you topic and need to mark as resolved.

Check if APT_PAD_STRING is ' '. Try to change it to 0x0 (Null). May be a case where empty space might be considered as pad chars. Try if that works.

Great work DSGuru2B.
The new member to Premium Poster.
Keep going. :D

You can let us know, on what basis the filename should be decided. So that the method can be decided.

Hi,
You can delete the other duplicate post created for the same topic.

If it is simple MAX function, database option will give you quick response. That again depends on how busy you database is.

Care to mark the topic as solved.

The job is aborted as it is asked for. Abort After n Rows will not give you the message that you want to, but will abort with the mentioned message. If you have value inputcolumn<>1 the job will abort.

I could not get the requirement clearly. Is TRIM you lookup data. You can use the pictorial representation if required. Will the Trim.code have 'XLT' as data?

You can use the Utility UtilityAbortToLog with the necessary error messages passed based on the condition in transformer.

What if you convert the database stage into sequential stage for the newly added field. If the error disappears, you can find the difference between the other links to that. Have you tried with the IPC as suggested in some previous post?

Are you trying to pass the password as parameter, if so check if that been passed correctly. Try to hardcode the values and check.

As mentioned, search will give you many results. But why do you want to abort the sequence if it has stoped executing the rest of the Jobs?