DSXchange

I am getting the following error while I am importing a job which is in 8.0 version in to DS 7.5 version
"file.dsx does not appear to be a valid DataStage export file or is from an incompatible release."


Is it not possible to import a job which is in a different version?.

Please help.

I executed a job on the DS m/c. This job ran fine for an hour after that the job got aborted because of the following error.
main_program: The section leader on DS m/c died

Can any1 please explain me why the job got aborted?.this job ran fine before. should I re-run this job?.

I cannot access Teradata from stored procedure. So I am writing a shell script.
#!/bin/ksh
TDServer=myserver
User=myusername
Pass='mypassword'
bteq<<EOF
.logon TDServer/User,Pass
select count(*) from Database.table;
.quit;
exit


I can schedule this in crontabs.
Is this a good idea?

Can you please explain me how I can call this stored procedure in Datastage . I am working on Parallel extender.I mean what stages I should use?.

If I write a simple SQL statement this will fulfill my purpose.rather than going for a datastage job. Delete from YYY; INSERT INTO YYY SELECT * FROM XXX; ; : repeat for all the tables If I write the SQl statements for the bunch of tables.How can I schedule them?. is there any procedure to schedule a...

I cannot drop the table because at any point of Time it should have 2 months of data
Current month and
Previous month.

Thanks for the reviews.

I am sorry,I forgot to mention. The tables are Teradata tables. Can I achive loading all these tables in single flow?.

I have Teradata tables(XXX) and I have to load these tables in to different Teradata tables(YYY) for back up. Before I load the data in to the YYY tables I have delete the data in the YYY tables and load the data from XXX tables. This should be done in a single flow. is it possible?.Can anyone pleas...

My datastage job pulls data from a teradata table and writes it to flat file. This table exists in DEV and TEST but is not present in Production. DBA has created a view instead of a table. This view is from 2 different tables. This job runs fine using the table on Dev,Test but fails when using the v...

gunzip -c file.gz | awk -F"\t" '{if (NF != columncount ) print NR,NF,$0}'


This command worked for the large files too. I did close the Unix box and re-opened and used the command again it did work.

Thanks for your help

gunzip -c file.gz |awk '{print $1}'|more

I am not sure if I am using it right or not. When I use this command it says file is too large

The unix command to see the incomplete records.
awk -F"\t" '{if (NF != 13) print NR,NF,$0}' filename.txt|more

This is good for txt files.
But what is the command for zipfile.
filename.gz(format)

Could any one please help.

awesome! it worked.

Thank you for your assistance

Thanks for your assistance.Let me try this.