DSXchange

Always choose your tools according to the job at hand - the UNIX sort will work much faster at large volumes than either Server or PX sorts or aggregators can. Any datatype sorted in DS can also be sorted the same way using the UNIX sort. The timestamp will either be an integer value representation ...

Abhijeet,

no, there is no builtin function in PX to do what you want.

Kumar, I touched upon the explanation earlier. The data set file header contains information on the partitioning, schema and data file paths. You cannot build this file manually, but you can create a new one with the same partitioning and schema information as the broken one and look at the new file...

Bala, your column "first_name" is misdefined. What is your defined quote character? What is your definition of the "first_name" column and what is the data (you just need to copy one line, since the error is occuring on each line)? The error message is telling you that you have a metadata mismatch b...

Jasper, the reason that the aggregator is using so much memory is because is it doing it's own sorting prior to aggregating. If you were to sort the incoming data using your UNIX sort (or CoSort/SyncSort if you have them) and then telling the aggregator stage that you are working with sorted data yo...

Please check the job you are calling to make sure that the names are still correct, if a called job changes parameter names then the calling sequence needs to be changed as well. And it would be a smart move to give the parameter a more descriptive name than "ParamName".

Roy, it doesn't really contain any information except the links to the actual component data files. If you don't mind artifacts, delete the file and have the job re-create it. If you need the data files then creat a new one, see where the part files are located and what they are called, and overwrit...

Roy, have you tried any other orchadmin commands on the file headers? I'm not at a system right now, but the option that gives you the details on the file. I do see that orchadmin spits out version information about the internal structure; I wonder if a corrupted header file might generate that erro...

You are trying to set a value for the parameter called "ParamName" and this has not been defined. The most common cause of this is just copying an example from here or the documentation - since the used of {ParamName} is meant as a placeholder for you to put in your own parameter name.

Yes, there are several built-in functions in PX. The one you choose depends upon the stage where you are looking to do this and whether the number is an integer or a floating point one. Please look into you documentation and you can use the search string "from_string" to get some of the functions - ...

Ravij, if you purchased DataStage from Ascential/IBM or a distributor with a service agreement then you need to contact them with your questions. Part of what you or your organisation pay goes to financing the support organization. Depending upon the level of support you have opted for you will get ...

Deepthi, you cannot do this from DataStage; it needs to be done from Excel. You still haven't shared whether you are doing a sequential read from an exported .csv file or if you wish to read from the Excel sheet using ODBC. In either case you will need to split the sheets. I think it is probably bes...

Excel .xls datasources are presented to DataStage using the Windows ODBC interface. You can read Excel sheets that have been exported to .csv form using sequential file stages. In either case you will have to work with just one worksheet at a time. This is more of an Excel or an ODBC question than a...

What's happening, Roy? The DataStagers are racking up the points; join now before it's too late

Kali, I remember changing my location to "Europe" about a month or so ago, since I realized that just putting in one country wasn't quite accurate. After I saw your post I went back to edit my profile and I'll be darned, but I can't find out where I changed my location; neither of the two profile sc...