DSXchange

Try chaging the link type or check the reject option. Your problem is still not clear.

Regards
Ashwin

Thanks alot, never tried that

Well what Tiago suggested, is a good way of doing the change in file and then processing it.

Ashwin

No Phil

We didn't use any Project environmental variables.

Ashwin

I am not sure
May be you can try using CurrentDate(). If it works let us know.

Ashwin

Hi Amar

Try playing with MonthFromDate and MonthDayFromDate and DateFromDaysSince. I guess it will help you. Otherwise please explain more so that we can help you.

Regards
Ashwin

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 Hi Eric You mean you have records like a||b||c||123||d|| Did you try specifying || as delimiter? Other way out is that you ch...

Hi Phil We did this in a bit different way. We were supposed to three different directories for Development (dev) , UAT (int) and Production (prod). The manner in which we did it is, we kept the entire directory structure and file naming convention same on all the three servers. While parametrising ...

Hi, Its working..... What I did is I converetd the dates to DateTostring in the stage variables And then I used them at the derivation(Transformer Stage) as, If AsInteger(Date1) = AsInteger(Date2) Then X Else Y. Cheers, Spendem Hi Spendem But I guess there is no need to conver it to String and then...

Hi Bala Have you checked the following things ? ORACLE_SID Is APT_ORCHHOME/bin present in ORACLE_HOME/bin in your path? I am not sure if in Oracle also you need to specify the schema name as in DB2. You can check for this. Though it seems silly. And can you let us know in what form you are specifyin...

Hi Om

What exactly is the problem you are facing? Is it that you are unable to findout how to get the current date in the where clause or something else?

Regards
Ashwin

Hi

Is there any additional constraint for the failure of summarized data or is it the same as molecular data? If it's the same then you can easily implement it in your ETL design by using a transformer and some constraints or stage variables.

Regards
Ashwin

Hi All

I am just having a suggestion : - Is it possible to have a seperate forum for DS MVS. I think it will help those who are working on DS MVS DS 390/


Regards
Ashwin

Hi Sundar To answer your specific question. Whenever you are using a lookup just ensure that the data which you are looking up and the data in primary file should in same partition. To ensure this your reference file should have either Entire partitioning or it should have the same partition method ...

Hi Sundar

Selecting partitions depends a lot on your requirements and job design.

I would suggest that you go through the User guide to understand in detail how partition works and which on you should use in a particular case.

I hope that helps you.

Regards
Ashwin

Hi

Try using StringToRaw as the underlying datatype for VarBinary is Raw. I hope it will help. Though I haven't tried it.

Regards
Ashwin