DSXchange

Hi,
You can use UNIX command who -d
This will give you list of dead processes

Ketfos

Hi, I tried as suggested by Ray. It didnot make any difference. Then I saved my changes and closed the job Then I opened this job again. When I view the data, I get the correct records based upon the changes in the column selections I had done. But when I review the SQL statement, it still reflects ...

Hi , I have a job. OracleOCi8 ---- Transformer --- OracleOCi8 In the input stage, I select Fully generated SQL Query in Query type list box. Then I click Build. I get Build Fully Genrated Query WIndow. I select my table and click on Select to select columns. I hit the query tab in above screen to vi...

Hi,
If the idea is to write null value, use datastage system variable @null.

Ketfos

Hi, My assumption is that you ahve three input tables 1) STG_JOB_EQUIPMENT 2) STG_CUST_RETURN 3) STG_JOB_RETURN Target table is FCT_JOB_EQUIPMENT From three input sources, you are writing to the target table. When the record is inserted from STG_CUST_RETURN, you want to write value "Returned by...

Hi,
DSX is for routine that support supplied Transforms, while DSU is for user-written (that is, written and third-party providers, not by Ascential).

Ketfos

Hi,
Is it correct translation .
If the datatype is defined as Long in Oracle, define it as VarBinary while reading in datastage?

Ketfos

Hi,
Is it correct translation .
If the datatype is defined as Long in Oracle, define it as VarBinary while reading in datastage?

Ketfos

Hi,
I was curious to know what are your input datatypes in the source Oracle table.
As I understand you are writing from Oracle source to Oracle target through datastage job.

Datastage doesnot support Oracle datatype Long?? Is it correct??

Ketfos

Hi,
One way is use the routine given below

Ans = Convert(Arg1, "", Arg2)


Where Arg1 is your string of characters you wish to remove in output
Arg2 is the input string

e.g

Arg1 = abcdefshijklmnopqrstuvwxy
Arg2 = HS2002156817161-1

Hope this help.
Ketfos

Hi,
You can put these list of values into a table.
Then select MAX(column name) from table

Ketfos

Hi, I get the following error while compiling a Sequence job in DS 7.5 ----- <JobSeqGenError> <Code>2017</Code> <Desc>XML parser error on input line 0: source='', reason='The system cannot locate the resource specified. '</Desc> <LineNum>0</LineNum> <Line></Line> <Ref></Ref> <Version>7.5.0.25</Versi...

Hi, I have a sequencer job. In the Wait for File Activity Stage, I need to define the input file name. I pass this file name as combination of parameters, the way you mentioned #Seqpath#/#Devenv#/test.dne .....this is on unix In the job properties - job control, define this two parameters as string....

Hi,
You can define these parameters in Job Control Properties and then pass them

#SeqPath#\#DataEnviron#\FDM\JobParmsSeq

Ketfos

Hi,
I think ER/Studio from Embarcadero technologies might supoort IBM's Red Brick Warehouse tool.

Ketfos