DSXchange

Hi ray,

COUNT DS_JOBS WITH NAME LIKE "1A0X"

"1A0X" --> What does it mean?


could you Explain!

Try this command from Administrator

UPDATE DS_JOBOBJECTS SET READONLY = 'NRO' WHERE NAME = '<Job Name>';

Regards
Hexa

Hi Arnd,

I tried using EREPLACE(BlobColumn,CHAR(nn):CHAR(nn),',') but I am not able to get my output in a single line.


regards
hexa

May be restart(close) u r datastage and try.

Hi

Is the metadata the same for the input file and what u have defined in your DataSet Stage?

Are there any extra columns defined by u that are not present in the input.



Hexa

Hi!

I need to use the routine. Its a must
I know there are other easier ways of doing it but i need to do it in basic

Anyway Thanks for ur reply and guide me if possible

Hi friends, I want to write a before subroutine that finds out whether a field is null or not and if it is null then gives the field a value =0 i have written the following code OPENSEQ "D:\DS325Files\SalesRecord.txt" TO H.LKEY ELSE ErrorCode = 1 Call DSLogInfo("Error in Open",&q...

Do you use a hammer to fasten wood screws? Or a sieve to cart water? Use the right tool! The Pivot stage does horizontal pivots. The Aggregator stage does aggregation. The FTP stage does FTP. And so on. That's the main principle underlying the graphical paradigm that DataStage uses. So the grouping...

Hi!

Thanks for ur reply
I will try it tommorrow at work

Hi I hope ur record has a primary key u can use the aggregator stage to find the last value of this column in your file. u can also use some other column that will have a unique value. Later u can use the transformer stage and place a constaint to add only that record to the output file which has th...

Hi!

I am new to datastage
I want to know the syntax for clearing the hash file(clearing its data) through the command option in the administrator

Thanks

Hi,

I want to know why the grouping functionality is available in the PIVOT stage
As we cannot do any aggregate function in this stage

I tried grouping and it gave me the same answer as it would give without grouping. I am failing to understand the importance

Can any one explain?

Thanks

Hi Friends!:)

I am new to DataStage.
I am facing difficulty in understanding DS Constant
I want to know what DS Constants exactly do and how and where can i use them

Thanks

Hi Friends!


Thanks for ur replies
This is a before routine I am using in stage properties. I am doing the lab exercises provided by Ascential

Also i would like more guidance on the method sugessted by Ray on avoiding the routine and writing to another hashed file for lookup

Thanks

Hi Friends! I have created a hash file that stores the last surrogate key used in a table The Hash file has two columns: TableName(key field) and SurrogateKey I have a routine that accepts Tablename as a parameter and then reads from the Hashfile and gets the last usedSurrogatekey for that table My ...