DSXchange

Hi, We got new connector stage few days back and today i noticed that the connector stage replace the connection parameters by the run time value. I have set the connection parameter to #pSSILSid#, #pSSILUser#, #pSSILPassword#. But it has replaced the runtime value of the parameters to the connectio...

Many thanks AndW. I have started analyzing the code as I have issues with string like one discreet chain. For example 1,2,3 to 1-3 or 1,2 to 1-2 or 1 to 1. I will post the modified code here. Many thanks for your time and baseline code. I can't imagine being employed in a ds job with out dsxchange :D

Hi, We need to form a range pattern to the stings we have. For example 213,001,052,219,220,221v,051,106,102,210,212,103,101,104,211,105,201,202,203,204,205,206,207,208,209,214,215,216,217,218 Should be converted to range pattern as below 001,051-052,101-106,201-221 The input string is sorted and ran...

I have a delimited text file with a spaces appended to all the fields and thus it appear to be a delimited fixed width file. I read the file with delimiter defining the columns. If the actual length of the field is less than the defined column length, then the field will have space appended to them....

I got solution in SQL from oracle forum. Please find the link below . http://forums.oracle.com/forums/thread.jspa?threadID=1057751&tstart=0 But the recurssion goes up to 54000 records! The SQL was taking infinite time to produce the output. We don't have a SQL DBA.So I handled it using PL/SQL. C...

Hi,

Will datastage support SGML in XML stages? I have to extract the data from a legacy application which has API to retun the SGML. Please share your inputs

Many Thanks
MSR

I'm surprised the PL/SQL reached cursor limits - is the source data that big and has that many levels? Using stage variables and/or routines in server would necessitate that the data fit into virtual memory, is that the case? The source data is 0.5 million nad it has more than 2000 levels. (or may ...

This type of recursive programming is not done easily directly in DataStage PX. I'd use a server job or stage as the BASIC language supports recursion or, if the data comes from a database, use SQL to solve the lookup recursion. Thanks Arndw. Can you please give me some idea on how to solve it with...

I have an interesting problem to solve using datastage. I'm not able to derive a solution. Please help if you can The table in interest has two attribute Item and Part. I need to form a group records based on deep-derive part key combination. For example Item Part I1 P1 I1 P2 I1 P3 I2 P4 I3 P3 I3 P5...

The '-' sign in your output line was confusing, it made it look like negative value lists were being returned. I can't check now, but perhaps the pivot stage is incompatible. What happens if you write a small dummy job using the px pivot and seeing if you get the same abort? Many Thanks for the rep...

And what was the result of DSAttachJob() ? (The best way to check is with some innocuous function like DSGetJobInfo(JobHandle, DSJ.JOBNAME) and log the value of the result. If this returns DSJE.BADHANDLE then your attach failed.) My DSAttachJob was not creating the issue. If we see the original log...

Thanks for you reply Any negative number returned from a DataStage API function indicates an error. The error codes are documented in JOBCONTROL.H header file in DSINCLUDE. You can probably search DSXchange to find them. Without seeing your job design it's difficult to comment further. ? It is happe...

The DSGetStageInfo() using DSJ.LINKTYPES will get you that information. Thanks Arnd for your reply. I got couple of issues in this regard 1) When I get the LINKTYPES for Dataset (as Target) and Lookup Fileset (as Source) then I'm getting Fatal error as given below TEST #1 ******* Arg1 = 1 Test comp...

Is there any way we have to find a link type as Stream, Reference or Reject from DS routines? I know there is a function to classify the stages DSGetStageInfo(JobHandle, StageName, DSJ.STAGETYPE) but don't find any thing as such for links. I had a Routine called after every job in sequence which sho...

Hi, The source files are pushed into landing directories in undefined times. On any time we may get a new version of a file. I had a requirement to select the file from the latest version sub-directory. And different files will be in different versions. For example -SrcDir -------SDA1 ------------Su...