DSXchange

A better option would be a db order by rather than a sort stage for that amount of records. Do as ArndW suggested. Put the orderby clause in the sql select. You might have to go for user defined sql. Look into it. In the OCI stage, in the sql tab, click on column generated sql query and click the b...

ravij wrote:Hi thanks for quick response.

Do u mean that should i write the user defined sql at source(database) level to sort the records?

thanks in advance

You can use a sort stage to sort the records

Hi everyone, I am using DS server edition 7.5.1 with DB2 running on unix server. I want to set the environment variable value in one of the jobs as a result of some intermediate calculations. This new value must be used in all the other jobs as the environment variable. Can this be done and if yes ...

Hi, I have a file that contains delimiters of 2 characters (e.g. ||). How can I read this file because DS Designer accept only a delimiter of 1 character? Kind Regards, Erik There is one way of doing it.. but is a round about way. Say you have three fields a||b||c Now when u define the table defn f...

No problem. This just illustrates the need to not make any assumptions about environment in your scripts. This applies in general but especially when writing scripts for execution inside DataStage. We see tons of posts that basically say "My script works fine from the command line but not from...

Simple answer is - don't use relative paths in your scripts. Fully path the usage of the 'a.ksh' and 'b.ksh' scripts. Either that or explicity 'cd' to the directory in question in the script so that is actually does become the current working directory. Then your relative paths will work. Either wa...

Can anybody suggest whether it is possible to do this? No, it's not. Why do you think you need to do this? What are you trying to accomplish? We are trying to run few dataflex script and unix scripts using Datastage. Say I have a script test.sh in path /test and it calls two script inside in the fo...

Hi, The PWD variable is set by default to the path where the project sits. But is it possible to change that to the directory that we require. For eg, in my case, the datastage projects sit in the directory called /product/dstage/Ascential/DataStage/Projects/fiat_test but I want the PWD to be change...

thanks for ur reply .but i need the result to be in YEARS Why don't you try this (Iconv(date1,"D/DMY") - Iconv(date2,"D/DMY"))/365 When you do Iconv(date1,"D/DMY") - Iconv(date2,"D/DMY"), you will get the diff in days, so divide it by 365,which will give you ...

prasanna2100 wrote:is there any built in function to find the date difference of two DATE values

You can use the internal conversion as
Iconv(date1,"D/DMY") - Iconv(date2,"D/DMY")

Hi all we are sorry first of all that this post has been repeated. Let me come to the topic, We have not repetedly run the job knowing that it is generating the warning messages.... The source table is having 75000 records and so that it is keeping on generating the Log messages due to unique key v...

HI I ahve tried with REST , Reset but is not active , I am uanble to compile some jobs in this sequence .getting error message like ' cann't get exclusive access to excutable file job , job may be being monitored. Thanks If you have administrator rights why don't you try unlocking the job through a...

Check that you really do have MAZDA MX-5 MX5 as a row in the lookup table (not MAZDA MX-3 MX5). Check also that there are no trailing spaces causing the lookup to fail. I did check right now and there is a row in the lookup table for MX-5. Just to make sure that there are no trailing spaces, I dele...

Check that you really do have MAZDA MX-5 MX5 as a row in the lookup table (not MAZDA MX-3 MX5). Check also that there are no trailing spaces causing the lookup to fail. I did check right now and there is a row in the lookup table for MX-5. Just to make sure that there are no trailing spaces, I dele...

kumar_s wrote:Is it Make = AcutalMake And Mode = IncorrectModel?

Yes Kumar it is.I am using the above lookup