DSXchange

loveojha2

Check your [serveronly-system-variables] inside DSParams,
Can you see @NULL in that list,
If it is not there then add it there.

loveojha2

Pls find the query below: 1 select count(*) from table where to_char(dttm_sec)>to_char('2005-03-30 14:26:51'); [/size] Should be select count(*) from table where to_char(dttm_sec,'yyyy-mm-dd hh24:mi:ss')>to_char('2005-03-30 14:26:51','yyyy-mm-dd hh24:mi:ss'); 2 select count(*) from PS_LEDGER where ...

loveojha2

Now the where clause given in the source DRS looks like this DTTM_SEC > %DateTimeIn('#LastModifiedDateTime#')[b/] But if I give like this it's throwing an error saying ORA-01841: (full) year must be between -4713 and +9999, and not be 0 Can you please paste what is the value that is coming from #La...

loveojha2

ArndW wrote:try using an empty string ("") instead of the @NULL value.

May be a Zero would be more appropriate, since he is using it in an aggregator.

loveojha2

Then you can try doing it through a named pipe.

loveojha2

You can try replacing the comma(,) with a Char(10):Char(13)(which is CRLF) and writing it to a sequential file and reading it back into a Hashed file and using Hashed file for lookup.

loveojha2

I think you are using a Lookup (for the values coming from XML)

In that case

Code: Select all

select * from emp where empname in (?)

should be

Code: Select all

select * from emp where empname =?

loveojha2

81002 - Looks like its not a timeout issue, it is probably a issue related with Broken Connection.

Used

Code: Select all

SELECT * FROM SYS.MESSAGE WHERE @ID = '081002';

loveojha2

Use the following trigger condition

Code: Select all

JobActivityName.$JobStatus <>1

(Custom)

This should work fine.

loveojha2

Hey Anand as I said it would work well even with %datetimein('').
No need for going into Routine.

In fact

Code: Select all

%DateTimeIn('0000-00-00 00:00:00') > %DateTimeIn('')

is true.

So it is sure to run for all the rows (Initially), if it is coming as ''.

loveojha2

The last modified date is stored in the shared container. We have a where clause in the source DRS as Dttm_stamp_sec> %datetimein(#LastModifiedDateTime#) I need to convert the date of %datetimein(#LastModifiedDateTime#) to 'yyyy-mm-dd hh:mm:ss' format As i am not able to do it, we are getting error...

loveojha2

Thanks a lot, guys

loveojha2

Hi All, Thanks for the help so far. :) Is there any direct way provided by Asential through which we can get the results from the commands executed at the Datastage Adminstrator within a file or atleast within the clipboard. If there is not, is there any trick by which we can achieve the same. Thanks

loveojha2

raj_konig wrote:Thanks Arnd.

But I am not trying to lookup but to join.

And even tried Merge. BU this is not accepting any inputs.

rajesh

But what is your Join criteria or is it like a cartesian product?

loveojha2

http://support.microsoft.com/default.aspx?kbid=264012

May be this will help

DSXchange

Search found 358 matches

Re: Problem with Date in Shared container

How to get the result of commands executed through Admin.