DSXchange

Thanks Ray. I executed the query outside DS to select the max value of the field but it comes as 139. Not sure what to do as I could not read the complete message of yours as it is Premium Contents.

Hi, I am trying to extract data from SQL Server. The job aborts after extracting cpl of rows saying that ' Error in setOutputFieldAsInteger() for field '5' of output dataset '0', the value of 139 is either too small or too large to fit into an int8.' The datatype of the field is Tinyint and length i...

Thanks Chullet.

Yes. I am using version 7.5. Can you please let me know which routine can I check for this?

Hi,
Is there any way by which a text file can be attached with the DSSendMail routine?

I got the material from a friend. Thanks for the help.
If anyone needs this doc, let me know.

Can anyone please provide me the link if you know from where I can get the same. There is nowhere in net in which I am able to find the same.

Hi,
Is there any place from where I can get the DS server developer's guide?

Well... I would suggest to have a new col in each job which is popualted as @outrownum. You can later combine the @outrownum from each file and put it in a single file which will say how many rows were transformed in each of the job.

Thanks Sachin...
all I am facing the problem is in the OCI stage. It is not allowing me to have custom SQL statements. So I am unable to code the update statement with subquery in it.

Thanks Ray for the quick reply. But I am supposed to do that in the Update query where the data in the Oracle DB will be updated for that row only where we have the max(Load-Dt).

I hope I am clear with the requirement.

Sorry for replying late Arndw. Yes we checked the complete FTP process but couldn't find any clue for which this thing is happening.

Thanks

Hi Guys, I will appreciate if someone can help me out of this problem. I am trying to update few records ito Oracle thru DS server job as per the requirement mentioned below. I/P Data : Cust_Id Ack_Ind Ack_Dt 1 Y 2007-10-15 2 N 2007-10-15 Oracle DB Data :- Cust_Id Ack_Ind Ack_Dt Load_Dt 1 N 2007-09-...

Yes the Hexadecimal value in the input file is 0x5A 0x40 but but I am not sure why is this one getting converted into 0x5B in the output.

Hi, Please let me know if you can suggest any solution for my problem as follows. I have a file which is being NDMed from Mainframe box to Unix as a Fixed-width file. One of the fields in it has datatype as Char (2). The data in the First byte that field is '!' and 2nd byte is space i.e '! '. We are...