DSXchange

Just did several sample jobs and identified the point where it is going wrong on Windows: The below statement works fine on Unix, But on Windows this gives compilation problem. IF Trim(LnkGenerate.Name," ","B")='' THEN 1 ELSE 0 One surprising thing is that Trim(LnkGenerate.Name,&...

Yup, all other jobs compile and execute without any problems. Even this job worked fine when Trim() was changed.

Here is the log: Output from transformer compilation follows: Output from transformer compilation follows: ##I TFCN 000001 15:24:09(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5 Copyright (c) 2004, 1997-2004 Ascential Software Corporation. All Rights Reserved ##I TOSH 000002 15:...

Hi, We ported our DS jobs from AIX to Windows Server. During compilation on Windows we faced a problem with Trim(String,'D') and Trim(String,' ','B') functions. This was working fine on Aix system. When we changed this to just Trim(String), it compiled and executed fine on Windows. Is this a problem...

Thanks guys for the help. Telenet - Our customer is hesitant to use wc -l on Windows even though it works fine with the MKS Toolkit installed. So we were looking out for alternate method. Also they wanted us to do this using vanilla flavors of Datastage. jgreve - We have a C++ compiler installed whi...

Our coding is on AIX server, but the code will be later ported to Windows. So, We want to make sure that we do not use anything Unix specific, that may not work on Windows.

Hi, I had a requirement to count the rows in the input file and write the final count to the output. For this the solution I thought of is to use a C++ routine which counts the number of lines and return the total. This is called from the datastage. This is working fine and quite fast. My Customer i...

Thanks Guys. We have a MainFrame expert in our team now who is helping in coding COBOL routines.

To shuffle the data we have now implemented a method similar Knuth Shuffle . It seems pretty ok for small volume data. But we still need to check the performance for larger volume and see how it goes on.

Hi there, I am trying to explore the following features in Datastage MVS Edition (7.5x2) for Mainframes: 1) A routine to generate Random number. In Server Jobs or Parallel Jobs, we have random routines which generate random numbers, but I am unable to find the same in MVS jobs ( or did I not check i...

Yes, it was solved after doing windows clean-up and applying few patches. Since I didnt have privileges to do these, I just asked the windows administrator to do this maintainance task for Windows and install any patches. It seems to be some Visual Basic Problem as Ray has mentioned. Probably it is ...

I have a requirement to do simultaneous read and write to a DB2 table. I need to lookup a DB2 table, if a value is not found in the lookup, compute a new value and update the lookup table so that all subsequent input rows with same key will use the same value from lookup table. The steps I am doing ...

actually I will be processing this XML at a later stage by an external application :D .... so this is a requirement .... Well, after breaking my head after lunch, I got a solution for this which is a kind of workaround. The solution is as follows: During exporting in XML format, select "Output ...

yup...

I exported it to XMLTest.xml, and imported using Import->DS Components (XML) as you have mentioned

Some more info: This is how the header looks in XML <DSExport> <Header CharacterSet="CP1252" ExportingTool="Ascential DataStage Export (External)" ToolVersion="4" ServerName="127.0.0.1" ToolInstanceID="TestDM" Date="2006-07-21" Time="1...

Hi, My Datastage server is running on Win 2003, and client on WinXP. I exported one of the DS project in XML format to Desktop. When I tried to import the same into a different project I got the error pop-up message iven below: File C:\Documents and Settings\Administrator\Desktop\$XML2DSX.dsx does n...