DSXchange

Thanks Ray As suggested,we ignore this error,since we are using server edition only. I have one more thing to discuss... While Installing Infosphere 8.5. I had selected below option only IBM Infosphere Datastage Server(select this option to develop server jobs) I have choosen the products(IBM Infosp...

Thanks Ray We are licensed for installing server edition(datastage,qualitystage and metadata Brokers and Bridges) only.... I have selected only to install server edition only while installing. Can you please let me know if this error effects anything in future if we are going to use only server jobs...

Hi Ray We have tried installing Infosphere 8.5 server edition on Windows server 2003. We got the below error during installation.... Installation exception: The installation program encountered an unexpected error com.ibm.is.install.exception.ActionException :CDIIN5075E:MKS installer: The OE install...

Thanks.I have tried this and it is working.





Thanks
Kiran

Hi Ray Can you please let me know how to implement this logic in server job or in the source sql query Input : Account id Flag 123 Y 123 Y 124 Y 124 N 125 N 125 N Output : Account id Flag 123 Y 124 Y 125 N In the source, If there is flag as 'Y' for any of the one record with the same account id ,we ...

Hi

We are planning to install Infosphere 8.5 on windows 7 i3 processor.we have Infosphere 8.5 64 bit installable with us.

Can anyone please let me know is it possible to install Infosphere 8.5 on i3 processor? or do we face any issues on installing on i3 processor.


Thanks
Kiran

FYI.We are using Datastage 7.5 server edition

Hi Ray

I will be more specific.

Source

2008-10-14 19:39:09.679

Expected Target

2008-10-14 19:39:09.679


I am able to load data into target which is 2008-10-14 19:39:09
but not "2008-10-14 19:39:09.679"

The millisecond sholud be captured(.679)


Thanks
Kiran

Hi I am trying to load date(along with time)from seqfile to Oracle table. Source(Seq file) -Timestamp Target (Oracle table) - Timestamp I also want the time to be populated in target. Source 2008-10-14 19:39:09.000 Expected Target 2008-10-14 19:39:09.000 Note : Oconv(Iconv(Substrings(Extraction_Data...

Hi Sunny Below is the code which wries the log details into .txt file The input argument is only the directory name.Here no need to create the file before. $INCLUDE DSINCLUDE JOBCONTROL.H ErrorCode = 0 DirName = InputArg Suffix = ".txt" JobHandle = DSJ.ME JobName = DSGetJobInfo(JobHandle,D...

Hi Sunny

Can you post the code you mentioned it worked......
and also can you explain with example teh arguments passed and the file path created....

Thanks
Kiran

We are not allowed to download any external applications

Sunny

Can you please post the latest code(after job sub routine) which writes job name,job start date and time,job end date and time tion to seq file



Thanks
Kiran

Hi sunny

Can you please post the latest code(after job sub routine) which writes job name,job start date and time,job end date and time tion to seq file



Thanks
Kiran

Thanks.Oconv(Date(), "D-YMD[4,2,2]") : " " : Oconv(Time(), "MTS") is not giving the correct timestamp when the job is ended,but it is giving exactly the time when transformer stage ended. As earlier told by Shruthi we have after job subroutine that would write this info...

Thanks.I have got the info in log.how can insert that in oracle table? I hava a routine which does this.but I am not sure the arguments i need to pass to this routine. Can anyone let me know on this $INCLUDE DSINCLUDE JOBCONTROL.H Equate RoutineName To 'GetJobInfo' Deffun DSRMessage(A1, A2, A3) Call...