DSXchange

Nothing seems wrong with the ODBC con . I have checked it using C# code and it returns the proper value and not a truncated one.
any other setting i should check for ?

I am afraid it is giving me the same result with LongVarchar as well

Hi, I am reading a varchar(8000) column from MSSQL Server 2000 using SQLServer enterprise Stage. The actual value in the column is 2300 characters. The output from the job is a truncated string of 255 characters followed by char(0) characters. The total character count in the output is 8000. sorry i...

Hi,

I need to call a MSSQL server stored procedure from DS and the stored procedure stage in this version only supports Oracle .

Is there any way I can call this SP other than using SP stage?

I found Ray's comment saying it can be done using an ODBC stage (?)

thanks,

It looks like your record will have minimum 4 cols ..
If so you can read your file using following schema in seq file stage
Col1
Col2
Col3
Col4
RemCol
(?)

how about this ...

If DateStr=DatetoString(StringtoDate(DateStr,"%yyyy%mm%dd"),"%yyyy%mm%dd") Then valid else invalid

description : I got a job abort with an err saying " xf_OpCnt,0: Fatal Error: Unable to initialize communication channel on SRVDA007. This is typically caused by a configuration problem. Examples of typical problems include: 1) The temporary directory, identified by $TMPDIR and/or the scratch d...

Hi , while using hoursfromtime function if hours from Time 1 is greater than hours from Time 2 just add 24 to the time 2 hrs and then do the calculations. eg. Time 1 - 23:59:59 Time 2 - 00:00:01 if hoursfromtime(Time 1)>hoursfromtime(Time 2) then {hoursfromtime(time2)+24} else hoursfromtime. so outp...

Hi there, If you have two time columns like 20:20:20 as HH:MM:SS then i think it can be done this way, use hoursfromtime,minutesfromtime and secondsfromtime function in variables, get the difference between two columns in variables in hours,minutes and seconds. multiply diff in hr by 3600,min by 60 ...

if RCP is used for Aggregator stage only those column will go to output , which are there in the mapping tab of aggregator on the left side(left side on the mapping tab).I have tried it once with sequential file as input to aggregator and sequential file as output to aggregator. Is this interview qu...

Hi csrazdan,

I tried it and it worked

cheers,
ZDC

Hi there,
As DSGuru suggested ...
Just go to
format tab>type defaults and then go for the date ,
change the format string to %yyyy%mm%dd in the output tab,it will work for sequential file as i have done this in past.No need to worry about datatype.



Cheers,
ZDC

Sai, This is hit and trial solution,Please use Oconv function with different options for the value 14567 in 7.5.2 version and check out for which option it returns you value 20071118 or 2007 11 18 and then use that option. if it didnt work then please contact ascential suport for this problem. I hop...

Hi there,

Actually it sounds very strange.Could you provide some sample date data and differences in results in the DS versions.

Cheers,
ZDC