DSXchange

You can also write a dummy job which uses a row-generator to generate one row, then a transform or filter to remove that one row and write to your dataset; that will do the same thing as the command-line would, it creates an empty new dataset. even i thought for the same but wanted to know more fro...

Thanks Ray.

So Data set truncatation will just remove Data file and will convert data set to a 0 byte file, keeping descriptor file as it is?

Hi,

I just want to convert it to ZERO byte ds not to remove.So i think if i remove data file , it will work? can i fire rm command to remove datafile?

Hi,

I have some space issue due to which i want to just remove data form a dataset and convert it to ZERO byte DS after loading to a DB table. how we can do this through UNIX/Data stage?

I think we need to use the key on which we are going to aggregate.if its a single key than it should work.

Hi, Read the file and in a transformer check if it contains a date value in satage variable. if so move some flag value in seq file and in transformer use the property abort after no of rows as 1 row. file -> Tfm- Actual file processing | seq file (which contain some flag, if so ABORT) Hope u can ab...

Actually what happend i was using sqldeveloper to access Oracle DB. When i was updating records for unit testing i was doing commit but it was not working then i used commit option given in sqldeveloper which worked. After that when i ran before and after SQL it worked perfect for me. So basically i...

There was no error msg. It was some DB connection issue.

Its resolved now. Thnaks for your help.

ArndW wrote:in that case, did you include the schema name? ...

Yes..

It's actual oracle DB table name which i need to update.

In Before SQL just giving as

UPDATE
Table name
SET
Clm = 'A'
WHERE Clm In (' ','B','C','E','9') ;

Same query is working in DB but not updating through DS.

Hi,

I am trying to update a ORACLE table using oracle connector in DS 8.7 through before and after job SQL.
It worked for me once but if i change the value for doing Unit testing its not giving proper results.
Please advise what needs to be done in such case.

Hi, In my job i am extracting data from Db2 EE stage and using partitioning table option. My query is like SELECT Col1, col2 FROM Tab A INNER JOIN Tab B ON ( A.Col1 = B.Col1 AND A.REPORT_DT=B.REPORT_DATE ) WHERE A.ID = '1234' AND A.REPORT_DT = 'YYYY-MM-DD' AND dbpartitionnum(A.Col1) = current dbpart...

Hi, I believe you are capturing rejects in seq file after loading to DB. In that case do like below Go to columns tab of the sequential file stage click on the column number and go to the edit column meta data window and in the Nullable properties specify the null field value as equivalent no of spa...

swarnkar wrote:

Virupan wrote:Hi,

How can I convert date format from 'yyyy-mm-dd' to 'yyyymmdd' format ?

You can delete " - " by using EREPLACE function

EREPLACE(columnName,"-","")

Nitin Swarnkar

u can also do like

date[1,4]:date[6,2]:date[9,2]