DSXchange

Hi all, In input stage i have a column STATUS which cant have Y or N or null. I used switch to seperate to two pipeline. null should go to N link. Bul i can handle null value to flow to a stream, it goes to Reject link. I tried with '' , "", @NUL, @NULL.STR , NULL but doesent work. But i can make i...

Yes it was running since Sep 12.
And... FIN_WAIT_1 ---> Waiting to dye

Hope we would see many question that were asked in Exams in our forum:wink:

Yes, if it is absolutely identified that, if the same question has been answered several time, an link can be given to one of some earliar post and the current post can be marked for deletetion. Later can be deleted. For any further query, the relevant earliar post can be followed up and comments ca...

Hi Top posters of Monthly/Weekly/All time, We all know that, very basic question been asked without even giving a single try on the search. It would be annoying for people who are exploring this site for very long time. We often ask them to search or provide a link which leads them to the Search pag...

There is a lates release in IBM site for the call of IBM Certified Solution Developer - WebSphere IIS DataStage Enterprise Edition v7.5 by the start of this year.
Prety cool stuff.
http://www-03.ibm.com/certify/certs/iisdwsdev75.shtml

This post was started for discussing the condition check for Null in switch stage. Where we cant use IF ISNULL(LINKNAME) logic in that. Later this post has been hijacked to experiment, how to hold a NULL value in Decimal/dfloat, apparently some of us are getting 0s instead of NULL in the nullable fi...

Hi,
You can try using Combine Record Stage to create a Vector records from a set of group records. From which you can use you Make Subrecord Stage to create the subrecords.
Hmm... 02 and 05 are the conventional figures used to mention the top level and sub level in the Mainfram aspect.

chulett wrote:You may also find that manually editing the file helps tremendously.

If you are confident and posses sound knowlege in Server, I personally feel the given documentation is more than sufficient. Once you done with the Documents, just stick to this forum, from which you can learn a lot, even more than a dedicated courses.

Hi, if i want to run the mapping in dec 05 then source will have amounts from jan 05 to dec 05. Since your input file have the cummulative ammounts, is it you want to find the difference only for current month and previous month or current month and sum of all previous month? What is your cardinalit...

You got the ip 100.200.10.15. Check with the system if any application is still running? If not, run $DSHOME/bin/list_readu to the list of locks. It might be a deamon running behind. Try to UNLOCK ALL. use ps -eaf | grep dscs to get the user id who holds the lock ( Probably you may not see any ) The...

If your date column is nullable, it should not get dropped.
Atleast it should hold '*********' in it.
Is you date parameter e30_dat_fin_mens converted to date format. i.e., if it is assigned as string, try with StringToDate().

Hi All- Thanks for your responses on the topic.The issue is resolved now. We have increased the number of processes allowed per user on the unix box from the existing 500 and increased it to a higher limit which was sufficient to handle all the processes kicked off by the ETL's. The batch finished ...

If you have the list of the tables, it would be easily done from unix shell script. Read the the table list, grep for the each table name in the main text, if found read untill a '.' is found. Append all the lines to a new file with the same table name '.txt'.