DSXchange

Guys, We have 2 CPUs, and each CPU has 6 cores and a 24 GB RAM on Windowsbox with DataStage 8.5. The CPUs are also hyperthreaded so when we create a Config File what is the best way to create a Config file in this case. Right now we have the below Config File. { node "node1" { fastname &qu...

I am using Aggregator to get the Max Value once i do that i get the output in the double datatype as expected. The output what i get is 7604 but expected is 007604.I will be using this data for join in the next Join stage but my join is failing as output isnt as expected as 007604. 2 Questions. 1) H...

Guys, I need to get Resultdate which is in between Two dates like below. FS.ResultDate BETWEEN PH.EffectiveStartDate AND PH.EndDate any suggestions how this can be done. I was using below logic. DSLink300.ResultDate >= DSLink300.EffectiveStartDate And DSLink300.ResultDate<= DSLink300.EndDate Doesnt ...

Any thouths on this Which Stage is really the best to Use in long run ODBC or SQL SERVER Enterprise

Guru,

I have SQL Server as Source and Target using DS 8.5 on WINDOWS 2008 and using mostly ODBC Connector. I was just wondering why cant i use SQL Server Enterprise stage. Any thoughts on this is apreeciated.

Thanks
Sri

See if this helps: http://www.dsxchange.com/viewtopic.php?t=140150 Hi Still i get the same error message below is my update statement UPDATE dbo.PatientCurrMedFact SET IsActive_YN = ORCHESTRATE.IsActive_YN, UpdateDate = ORCHESTRATE.UpdateDate, SourceOrderMedCode = ORCHESTRATE.SourceOrderMedCode, So...

I am reading data from staging and writing in to a dataset. Now i read the dataset and update an SQL Server Table while doing that i get the below message. SQLExecute" reported: SQLSTATE = 40001: Native Error Code = 1,205: Msg = [IBM (DataDirect OEM)][ODBC SQL Server Native Wire Protocol driver...

I am reading a timestamp field from SQL Server and loading back to SQL Server tables where i need to have the microseconds as 2000:01:01:15:30:00:510 But when i read and them and load to a target table i dont see the last 510 rather i see 000 instead just curious why this is happening ? At project l...

Hi Ray, I Executed the command but i got the same Error WARNING: Internal file corruption detected during file open! File must be repaired, possible truncation. hsize: 1024 bsize: 278441472 fsize: 533443 Filename: VOC Start Diagnostics. 0 Errors found in physical structure. WARNING: Internal file co...

Hi Ray, I executed the command you mentioned above.. your right it is problem with VOC file . and i got the below Error WARNING: Internal file corruption detected during file open! File must be repaired, possible truncation. hsize: 1024 bsize: 278441472 fsize: 533443 Filename: VOC Start Diagnostics....

I ran the command from the main project directory and got the following below error. bhd2iis001:/opt/IBM/InformationServer/Server/Projects/BHDEVCN1# /opt/IBM/InformationServer/Server/DSEngine/bin/dssh LOGTO BHDEVCN1 WARNING: Internal file corruption detected during file open! File must be repaired, ...

Hi , I'm getting the following error while connecting to one of the project Failed to connect to DataStage server: BHD2IIS001.BHDEV1.IBM.COM, project: BHDEVCN1 ( The directory you are connecting to either is not a UV account or does not exist (39125)) i searched the forums about this error . and i e...

I did change that now the error i get is as follows. ISTOOL Script -- /opt/IBM/InformationServer/Clients/istools/cli>istool export -domain bhpiis001.pok.ibm.com:9080 -v -u srpunuru -p Zaq1@wsx -ar /home/srpunuru/R1A_DEV_test.isx -ds '-incdep -base="bhpiis001.pok.ibm.com:9080/BHDEVCN" Jobs/...

./istool export -domain bhpiis001.pok.ibm.com:9080 -u srpunuru -p Zaq1@wsx -archive /home/srpunuru/test.isx -datastage ' -base="bhpiis001.pok.ibm.com:9080/BHDEVCN/Jobs/Abhinav/" ' Beginning Export Elapsed time: 00:00:00 Exported 0 assets I Tried to export the using istools and doesnt do an...

Team. I am trying to run the below script but i get the below issues. Need some thoughts on this please ! "./istool export -domain bhpiis001 -u srpunuru -p ibm123 -ar /home/srpunuru/test.isx -ds '-base="bhx001.bhdev1.ibm.com/BHDEVCN" Jobs/Abhinav/*.*' Beginning Export Export failed: P...