DSXchange

I dont have access with PX now. But what happens when you give DSLogInfo(parametername). Could you see the value in the Director log?

svar1 <-- If left(svar1,3) = input.col1 Then svar1=svar1 : input.col2 Else col1 In this case, you need to have your delimiter concatinated as well. Like svar1 <-- If left(svar1,3) = input.col1 Then svar1= svar1:",":input.col2 Else col1 This will work only for one column to be pivo...

What version are using? If it is 7.5.1A, batch job is for the same reason. You can find the New bath job from Director menu. The parameters usein the the job (Px job/batch job) can be used inside the code as well. So all those parameter given in the job can be used to call the different jobs. Or the...

loveojha2 wrote:The error suggests that it is trying to take in a numeric data type column (specified within the datastage), change it to timestamp and see how it works.

Sometimes it gives the same error if timestamp is not inserted in proper format.

Check with the input file size. Try to give atlest twice as large as that, if you have only one sort stage(that is where the current abort is in) in the job. Bear in mind that, the stages like, lookup, sort, remove duplicate, aggregator will use the scratch sapce. So more you of these staeg utilizat...

Or might be "Batch".
What are you doing with the job control. Are you trying to call a job with different parameters pass with different invocation ids?
If yes, it has been many times disscussed.

SIGSEGV is the right term to search for, I got 38 hits.

You are right. CFF in PX cannot change its metadata dynamically based on data, as what redefines is for. So either you need to seperatly process the data for different conditions othere than expected from soruce, before reading into CFF or use other stages to filter it out. Read it as varchar (if po...

1.There is no built in funciton, but you can biuld in. There is no seperate "DS sequential file" as such. If you point to a unix file, wc is the ideal option. If you are refering a file which are read through DS, you have variables like, @INROWNUM/@OUTROWNUM you can calculate it. 2. Yes there is. Wh...

Does even a input stage of DB2 give the same error?

First of all why have you removing lookup stage to a join stage for performance improvement because lookup always give better performance to join. dsusr Not in all cases. Untill the lookup data is small enough to handled in lookup memory, lookup approach is better. Once it is beyond certain limit, ...

Welcome Aboard :D

Complex Flat File in Datastage does this function. Have you tried with that stage. What is the result or output?

Datastage should also make a new count, if it come accorss a line feed in the data with the default settings.

In PX we have option to track even the those troublesome records from the passive stages by extending a reject link.

If you number of records per group is limited to 3, the above solutin will work out. You can also do this with a transformer and aggregator combination. Search for your title you will get lot of post. If you are not sure about the nubmer of records per group, writing a custom code will be your best ...